查看表定义语句

SQL> set pages 0

SQL> set long 1000000

SQL> select dbms_metadata.get_ddl('TABLE','表名','用户名') from dual;

select dbms_metadata.get_ddl('TABLE','ACCESS_SERVER','MEGAEYES') from dual;

"(CLOB)
CREATE TABLE "MEGAEYES"."ACCESS_SERVER"
( "ID" VARCHAR2(31) NOT NULL ENABLE,
"OPTIMISTIC_LOCK" NUMBER(19,0) NOT NULL ENABLE,
"F_NAME" VARCHAR2(255),
"NAMING" VARCHAR2(255),
"INSTALL_LOCATION" VARCHAR2(255),
"DEVICE_NUMBER" VARCHAR2(255) NOT NULL ENABLE,
"NOTE" VARCHAR2(255),
"IP" VARCHAR2(255),
"O_ORGAN_ID" VARCHAR2(31) NOT NULL ENABLE,
"STD_ID" VARCHAR2(32),
"IP1" VARCHAR2(16),
PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "MEGASPACE" ENABLE,
UNIQUE ("DEVICE_NUMBER")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "MEGASPACE" ENABLE,
CONSTRAINT "FK559FDE7EE52BDC19" FOREIGN KEY ("O_ORGAN_ID")
REFERENCES "MEGAEYES"."O_ORGAN" ("ID") ENABLE
) 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)
TABLESPACE "MEGASPACE"
"