通过查询表定义(DBMS_METADATA)来查看建表的更多选项

EODA@PROD1> create table t (a int primary key, b date, c clob);Table created.EODA@PROD1> select dbms_metadata.get_ddl( 'TABLE', 'T') from dual;  --<span style="font-family: Arial, Helvetica, sans-serif;">dbms_metadata.get_ddl</span>DBMS_METADATA.GET_DDL('TABLE','T')------------------------------------------------------------------------------  CREATE TABLE "EODA"."T"   ("A" NUMBER(*,0),"B" DATE,"C" CLOB, PRIMARY KEY ("A")  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255  TABLESPACE "USERS"  ENABLE   ) SEGMENT CREATION DEFERRED  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING  TABLESPACE "USERS" LOB ("C") STORE AS BASICFILE (  TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION  NOCACHE LOGGING )

这可以方便看出在不同情况下CREATE TABLE语句有哪些选项是可用的