imp show y - cheeyoung/sqlplus-public GitHub Wiki
...
"CREATE TABLE "STAT_TAB_BACKUP" ("STATID" VARCHAR2(128), "TYPE" CHAR(1), "VE"
"RSION" NUMBER, "FLAGS" NUMBER, "C1" VARCHAR2(128), "C2" VARCHAR2(128), "C3""
" VARCHAR2(128), "C4" VARCHAR2(128), "C5" VARCHAR2(128), "C6" VARCHAR2(128),"
" "N1" NUMBER, "N2" NUMBER, "N3" NUMBER, "N4" NUMBER, "N5" NUMBER, "N6" NUMB"
"ER, "N7" NUMBER, "N8" NUMBER, "N9" NUMBER, "N10" NUMBER, "N11" NUMBER, "N12"
"" NUMBER, "N13" NUMBER, "D1" DATE, "T1" TIMESTAMP (6) WITH TIME ZONE, "R1" "
"RAW(1000), "R2" RAW(1000), "R3" RAW(1000), "CH1" VARCHAR2(1000), "CL1" CLOB"
") PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT"
" 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TA"
"BLESPACE "........." LOGGING NOCOMPRESS LOB ("CL1") STORE AS SECUREFILE (T"
"ABLESPACE "........." ENABLE STORAGE IN ROW CHUNK 8192 RETENTION AUTO NOCAC"
"HE LOGGING NOCOMPRESS KEEP_DUPLICATES STORAGE(INITIAL 106496 NEXT 1048576 "
"MINEXTENTS 1 BUFFER_POOL DEFAULT))"
. . skipping table "STATS_TAB_BACKUP"
"CREATE INDEX "STAT_TAB_BACKUP" ON "STAT_TAB_BACKUP" ("STATID" , "TYPE" , "C"
"5" , "C1" , "C2" , "C3" , "C4" , "VERSION" ) PCTFREE 10 INITRANS 2 MAXTRAN"
"S 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST "
"GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "........." LOGGING"
Import terminated successfully without warnings.