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语句有哪些选项是可用的
通过查询表定义(DBMS_METADATA)来查看建表的更多选项
最新推荐文章于 2022-04-26 18:32:09 发布