set pages 999;
set long 90000;
SELECT DBMS_METADATA.GET_DDL(
object_type => 'TABLE',
name => 'APM_MIGRATION_TASK_DETAIL',
schema => 'PAASTEST'
) FROM DUAL;
DBMS_METADATA.GET_DDL(OBJECT_TYPE=>'TABLE',NAME=>'APM_MIGRATION_TASK_DETAIL')
--------------------------------------------------------------------------------
CREATE TABLE "PAASTEST"."APM_MIGRATION_TASK_DETAIL"
( "DETAIL_ID" NUMBER(12,0),
"TASK_ID" NUMBER(12,0),
"APP_ID" NUMBER(12,0),
"APP_NAME" VARCHAR2(100),
"UNIT_ID" NUMBER(12,0),
"UNIT_NAME" VARCHAR2(100),
"MODULE_ID" NUMBER(12,0),
"MODULE_NAME" VARCHAR2(100),
"DEL_FLAG" NUMBER(1,0) DEFAULT 0,
"APMC_ID" NUMBER(12,0)
) 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 "TAB_PAASTEST"
使用DBMS_METADATA这个包可以打印表的DDL,但是并没显示与表相关的索引、外键、约束的定义!?