1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
DBMS_METADATA.GET_DDL('TABLE','UISEC_HOST')
--------------------------------------------------------------------------------
CREATE TABLE "AA7020_PRD"."UISEC_HOST"
( "NAME" VARCHAR2(32) NOT NULL ENABLE,
"LOCATION" VARCHAR2(256),
"STATUS" NUMBER(3,0),
"EXPIREDDATE" DATE,
"GRANTPRIVILEGES" NUMBER(3,0),
"FULLNAME" VARCHAR2(80),
"REMARK" VARCHAR2(80) NOT NULL ENABLE,
"STARTINFO" VARCHAR2(80)
) PCTFREE 10 PCTUSED 0 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)
TABLESPACE "TS_AA7020"
1 row selected. |
Partager