oracle 10g _create tablespace相关语法

create tablespace mm datafile 'c:\mm.dbf' size 10m blocksize 8k force logging;

create tablespace mm datafile 'c:\mm.dbf' size 10m blocksize 8k offline|online;

create  bigfile tablespace mm datafile 'c:\mm.dbf' size 10m blocksize 8k force logging flashback on|off;

desc dba_data_files;

desc v$tablespace;

desc user_tables;

drop tablespace mm including contents and datafiles;

create tablespace mm datafile 'c:\mm.dbf' size 10m default nocompress;

create undo tablespace undo2 datafile 'c:\undo2' size 10m extent management local autoallocate retention noguarantee|guarantee;

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-608107/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-608107/