Sql> CREATE TABLE T_xifenfei as SELECT * from Dba_objects; Table created. Sql> Select COUNT (*) from T_xifenfei; COUNT (*) ---------- 90915 [Oracle@localhost ~]$ exp CHF/XIFENFEI@PDB1 file=/tmp/t_xifenfei.dmp Tables=t_xifenfei Export:release 12.1.0.2.0 on Sun APR 27 21:39:26 2014 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Connected to:oracle Database 12c Enterprise Edition release 12.1.0.2.0-64bit with the partitioning, OLAP, A dvanced Analytics and real application testing options Export do in Us7ascii character set and Al16utf16 NCHAR Cter Set Server uses we8mswin1252 character set (possible charset conversion) About to export specified tables via conventional Path ... . . Exporting table T_xifenfei 90915 rows Exported Exp-00091:exporting questionable statistics. Export terminated successfully with warnings. [Oracle@localhost ~]$ od-x/tmp/t_xifenfei.dmp |head-10 0000000 0003 4501 5058 524f 3a54 3156 2e32 3130 0000020 302e 0a30 4344 4648 520a 4154 4c42 5345 0000040 380a 3931 0a32 0a30 3237 300a 000a 0001 0000060 07b2 00d0 0001 0000 0000 0000 0000 0013 0000100 2020 2020 2020 2020 2020 2020 2020 2020 * 0000140 2020 2020 2020 2020 7553 206e 7041 2072 0000160 3732 3220 3a31 3933 323a 2036 3032 3431 0000200 742f 706d 742f 785f 6669 6e65 6566 2e69 0000220 6d64 0070 0000 0000 0000 0000 0000 0000 --strings command to see DMP file [Oracle@localhost ~]$ strings/tmp/t_xifenfei.dmp |head-50 export:v12.01.00 Dchf Rtables 8192 Tue APR 0:39:49 2014/tmp/t_xifenfei.dmp #G #g #G #g +08:00 BYTE Unused Interpreted Disable:all Metricst TABLE "T_xifenfei" CREATE TABLE "T_xifenfei" ("OWNER" VARCHAR2 (128), "object_name" VARCHAR2 (128), "Subobject_name" VARCHAR2 (128), "object_ ID "number," data_object_id "number," Object_type "VARCHAR2," CREATED "date," Last_ddl_time "date," TIMESTAMP "Varcha R2 (), "STATUS" VARCHAR2 (7), "temporary" VARCHAR2 (1), "generated" VARCHAR2 (1), "secondary" VARCHAR2 (1), "NAMESPACE" Number, "Edition_name" VARCHAR2 (128), "Sharing" VARCHAR2 (+), "Editionable" VARCHAR2 (1), "oracle_maintained" VARCHAR2 ( 1) PCTFREE pctused Initrans 1 Maxtrans 255 STORAGE (INITIAL 13631488 NEXT 1048576 minextents 1 freelists 1 freelist GROUPS 1 buffer_pool DEFAULT) tablespace "USERS" LOGGING nocompress INSERT into "T_xifenfei" ("OWNER", "object_name", "Subobject_name", "object_id", "data_object_id", "object_type", "" CREATED "," Last_ddl_time "," TIMESTAMP "," STATUS "," temporary "," generated "," secondary "," NAMESPACE "," Edition_name "," Sharing "," editionable "," oracle_maintained ") VALUES (: 1,: 2,: 3,: 4,: 5,: 6,: 7,: 8,: 9,: 10,: 11,: 12,: 13,: 14,: 15,: 1 6,: 17,: 18) Public V$dataguard_config Synonym 2014-04-22:17:51:05 VALID METADATA LINK V_$dataguard_stats VIEW 2014-04-22:17:51:05 --Destroy Exp DMP file [Oracle@localhost ~]$ dd if=/dev/zero of=/tmp/t_xifenfei.dmp bs=1024 count=1 conv=notrunc 1+0 Records in 1+0 Records out 1024 bytes (1.0 kB) copied, 6.0291e-05 seconds, 17.0 MB/s [Oracle@localhost ~]$ od-x/tmp/t_xifenfei.dmp |head-10 0000000 0000 0000 0000 0000 0000 0000 0000 0000 * 0020000 0064 0000 6000 2401 050f 0c0b 0c03 050c 0020020 0504 060d 0709 0508 0505 0505 050f 0505 0020040 0505 050a 0505 0505 0504 0706 0808 4723 0020060 4723 1108 0823 4111 47b0 8300 b200 d007 0020100 0003 0000 0000 0000 0000 0000 0000 0000 0020120 0000 0000 0000 0000 0000 0000 0000 0000 0020140 0000 0000 0000 0064 0000 6000 2401 050f 0020160 0c0b 0c03 050c 0504 060d 0709 0508 0505 --After the damaged DMP file use the strings command to see [Oracle@localhost ~]$ strings/tmp/t_xifenfei.dmp |head-50 #G #g #G #g +08:00 BYTE Unused Interpreted Disable:all Metricst TABLE "T_xifenfei" CREATE TABLE "T_xifenfei" ("OWNER" VARCHAR2 (128), "object_name" VARCHAR2 (128), "Subobject_name" VARCHAR2 (128), "object_ ID "number," data_object_id "number," Object_type "VARCHAR2," CREATED "date," Last_ddl_time "date," TIMESTAMP "Varcha R2 (), "STATUS" VARCHAR2 (7), "temporary" VARCHAR2 (1), "generated" VARCHAR2 (1), "secondary" VARCHAR2 (1), "NAMESPACE" Number, "Edition_name" VARCHAR2 (128), "Sharing" VARCHAR2 (+), "Editionable" VARCHAR2 (1), "oracle_maintained" VARCHAR2 ( 1) PCTFREE pctused Initrans 1 Maxtrans 255 STORAGE (INITIAL 13631488 NEXT 1048576 minextents 1 freelists 1 freelist GROUPS 1 buffer_pool DEFAULT) tablespace "USERS" LOGGING nocompress INSERT into "T_xifenfei" ("OWNER", "object_name", "Subobject_name", "object_id", "data_object_id", "object_type", "" CREATED "," Last_ddl_time "," TIMESTAMP "," STATUS "," temporary "," generated "," secondary "," NAMESPACE "," Edition_name "," Sharing "," editionable "," oracle_maintained ") VALUES (: 1,: 2,: 3,: 4,: 5,: 6,: 7,: 8,: 9,: 10,: 11,: 12,: 13,: 14,: 15,: 1 6,: 17,: 18) Public V$dataguard_config Synonym 2014-04-22:17:51:05 VALID METADATA LINK V_$dataguard_stats --imp Import DMP file failed [Oracle@localhost ~]$ imp chf/xifenfei@pdb1 file=/tmp/t_xifenfei.dmp full=y Import:release 12.1.0.2.0-beta on Sun APR 27 22:02:40 2014 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Connected to:oracle Database 12c Enterprise Edition release 12.1.0.2.0-64bit With the partitioning, OLAP, Advanced Analytics and real application testing options Imp-00037:character Set Marker Unknown Imp-00000:import terminated unsuccessfully |