QL> SELECT DBMS_METADATA.GET_DDL('TABLE', 'EOSROLE') FROM DUAL;
CREATE TABLE "COFCO_LAW"."EOSROLE"
( "ROLEID" VARCHAR2(64) NOT NULL ENABLE,
"GROUPID" VARCHAR2(20),
"ROLENAME" VARCHAR2(64) NOT NULL ENABLE,
"ROLECLASS" NUMBER(*,0),
"PRIORITY" VARCHAR2(2),
"QUERYSCOPE" VARCHAR2(30),
"DFLAG" CHAR(1) DEFAULT 0,
CONSTRAINT "PK_EOSROLE" PRIMARY KEY ("ROLEID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "COFCO_LAW" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "COFCO_LAW"