dbms_metadata.get_ddl()包()内的参数都要大写
看得到的信息是否都显示出来了?看看你的终端设置是否正确,set long 9999(随便设置他的大小,就是为了完全显示查找的结果)
SQL> set lines 200
SQL> set pages 999
SQL> set long 9999
SQL> select dbms_metadata.get_ddl('TABLE','T1') from dual;
DBMS_METADATA.GET_DDL('TABLE','T1')
--------------------------------------------------------------------------------
CREATE TABLE "U1"."T1"
( "A" VARCHAR2(10),
"B" NUMBER(10,0),
PRIMARY KEY ("A")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "USERS" ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "USERS"