oracle½¨Á¢±í¿Õ¼ä

1.oralceɾ³ýÃüÁî
1.1.ɾ³ýÓû§
drop user username cascade;
1.2.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE dataspace INCLUDING CONTENTS AND DATAFILES;
2.´´½¨±í¿Õ¼ä
2.1.½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE dataspace
DATAFILE '/Ŀ¼/dataspace.dbf' SIZE 500M
UNIFORM SIZE 128k; //Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏΪ64k
2.2.½¨Á¢UNDO±í¿Õ¼ä
CREATE UNDO TABLESPACE UNDOTBS02
DATAFILE '/oracle/oradata/db/UNDOTBS02.dbf' SIZE 500M
#×¢Ò⣺ÔÚOPEN״̬ÏÂijЩʱ¿ÌÖ»ÄÜÓÃÒ»¸öUNDO±í¿Õ¼ä£¬Èç¹ûÒªÓÃн¨µÄ±í¿Õ¼ä£¬±ØÐëÇл»µ½¸Ã±í¿Õ¼ä:
ALTER SYSTEM SET undo_tablespace=UNDOTBS02;

2.3.½¨Á¢ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE temp_data
TEMPFILE '/oracle/oradata/db/TEMP_DATA.dbf' SIZE 50M
3.Óû§²Ù×÷
3.1.´´½¨Óû§
create user username identified by password
default tablespace test_data
temporary tablespace test_temp;
  
3.2.ȨÏÞ
grant connect,resource to username;