设置显示格式使其显示完全
SQL> set pagesize 0
SQL> set long 90000
SQL> set feedback off
SQL> set echo off
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','CRM_AGG_USERBEHAVIOR_CALC1') FROM DUAL;
CREATE TABLE "DATAPROD"."CRM_AGG_USERBEHAVIOR_CALC1"
( "EUTIME" TIMESTAMP (6) DEFAULT sysdate,
"EID" NUMBER(38,0),
"USERID" VARCHAR2(100),
"ISPREMIUM" NUMBER(5,0),
"ISPREMIUMGS" NUMBER(5,0),
"ISPREMIUMJC" NUMBER(5,0),
"ISPREMIUMTZDS" NUMBER(5,0),
"ISFUNDTRADE" NUMBER(5,0),
"FIRSTPROVINCE" VARCHAR2(100),
"FIRSTCITY" VARCHAR2(100),
"LASTPROVINCE" VARCHAR2(100),
"LASTCITY" VARCHAR2(100),
"DFCFFIRSTDATE" TIMESTAMP (6),
"DFCFLASTDATE" TIMESTAMP (6),
"TTJJFIRSTDATE" TIMESTAMP (6),
"TTJJLASTDATE" TIMESTAMP (6),
"DFCFNUMALL" NUMBER(38,0),
"DFCFNUM180" NUMBER(38,0),
"TTJJNUMALL" NUMBER(38,0),
"TTJJNUM180" NUMBER(38,0),
"LASTUPDDT" TIMESTAMP (6),
"ISL2" NUMBER(5,0),
"GUBANUMKT" NUMBER(38,0),
"GUBANUMFT" NUMBER(38,0),
"GUBANUMPL" NUMBER(38,0),
CONSTRAINT "PK_USERID" PRIMARY KEY ("USERID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATIS
TICS
STORAGE(INITIAL 163840 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACH
E DEFAULT)
TABLESPACE "USERS" ENABLE,
SUPPLEMENTAL LOG GROUP "GGS_CRM_AGG_USERBEH_88435" ("USERID"
) ALWAYS
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 163840 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 214748364
5
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CAC
HE DEFAULT)
TABLESPACE "USERS"