dbms_metadata.get_ddl-获取对象创建语句

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"