Oracle dmp文件损坏恢复案例(二)

2014-11-24 17:18:16 · 作者: · 浏览: 1
661: BIND information for 3 columns

col[ 1] type 2 max length 22

col[ 2] type 1 max length 128 cset 852 (ZHS16GBK) form 1

col[ 3] type 1 max length 19 cset 852 (ZHS16GBK) form 1

Conventional export

2687: start of table data

2781632: TABLE "DH_STAT"

2781648: CREATE TABLE "DH_STAT" ("ID" NUMBER, "NAME" VARCHAR2(128), "TYPE" VARCHAR2(19)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIA

L 4194304 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS

2781914: INSERT INTO "DH_STAT" ("ID", "NAME", "TYPE") VALUES (:1, :2, :3)

2781979: BIND information for 3 columns

col[ 1] type 2 max length 22

col[ 2] type 1 max length 128 cset 852 (ZHS16GBK) form 1

col[ 3] type 1 max length 19 cset 852 (ZHS16GBK) form 1

Conventional export

2782005: start of table data

5898003: CREATE INDEX "IND111" ON "DH_STAT" ("NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 3145728 NEXT 1048576 MINEXTENTS 1 FREELISTS

1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING

5898339: CREATE INDEX "IND_2" ON "DH_STAT" ("NAME" , "ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4194304 NEXT 1048576 MINEXTENTS 1 FREE

LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING

5900617: TABLE "DH_STAT"

5900705: ENDTABLE

5900740: EXIT

5900745: EXIT