构，如下 DUL> scan dump file e:\test\test.dmp; 0: CSET: 852 (ZHS16GBK) 3: SEAL EXPORT:V11.02.00 20: USER DBMON 28: TYPE TABLES 2317: TABLE "DH_SQL" 2332: CREATE TABLE "DH_SQL" ("ID" NUMBER, "NAME" VARCHAR2(128), "TYPE" VARCHAR2(19)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 41 94304 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS 2597: INSERT INTO "DH_SQL" ("ID", "NAME", "TYPE") VALUES (:1, :2, :3) 2661: 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
（4）抽取dmp文件中的表数据，如下 1.抽取"DBMON"."DH_SQL"表数据 DUL> unexp table "DBMON"."DH_SQL" ("ID" NUMBER, "NAME" VARCHAR2(128), "TYPE" VARCHAR2(19)) dump file e:\test\test.dmp from 0; DUL: Error: column 1 length 771 exceeds max bind size 22 0000000000 54455850 4f52543a 5631312e 30322e30 TEXP ORT: V11. 02.0 0000000016 300a5544 424d4f4e 0a525441 424c4553 0.UD BMON .RTA BLES 0000000032 0a323034 380a300a .204 8.0. 0: column 1 type NUMBER size 771 failed 0: row 1 failed row conversion failure, retrying from offset 1 2687: succesful conversion 2687 bytes skipped due to conversion problems DUL: Error: Bad digit in number 222 (0xdf) 0000000000 c3df03d2 .... 2897: column 1 type NUMBER size 4 failed 2897: row 7 failed row conversion failure, retrying from offset 2862 2925: row 7 partial success 2960: succesful conversion 63 bytes skipped due to conversion problems DUL: Error: column 1 length 3844 exceeds max bind size 22 0000000000 ddf20406 13d05359 535f594f 49443030 .... ..SY S_YO ID00 0000000016 d0303f31 30333034 24040054 59504500 .0?1 0304 $..T YPE. 0000000032 000400c3 0204050c .... .... 3109: column 1 type NUMBER size 3844 failed DUL: Error: column 1 length 21835 exceeds max bind size 22 0000000000 245f524d 47525f50 4c414e5f 54040054 $_RM GR_P LAN_ T..T 0000000016 59504500 000400c3 02050f13 00535953 YPE. .... .... .SYS 0000000032 5f594f49 44303030 _YOI D000 3109: column 1 type NUMBER size 21835 failed 3109: row 12 failed row conversion failure, retrying from offset 3085 3144: succesful conversion 35 bytes skipped due to conversion problems DUL: Error: column 1 length 223 exceeds max bind size 22 0000000000 c302040a 13005359 535f594f 49443030 .... ..SY S_YO ID00 0000000016 3030f031 30333038 24040 |