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;