oracle倒入库倒不进表,expdp导出一张表没有问题,impdp导入不进去

本帖最后由 urlgaojian 于 2011-12-20 13:09 编辑

[oracle@server2 ~]$ expdp uxx/123 directory=full_dir file=aa_person_health.dmp log=aa_person_health.log tables=aa_person_health

Export: Release 11.2.0.1.0 - Production on Tue Dec 20 10:24:22 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

Legacy Mode Active due to the following parameters:

Legacy Mode Parameter: "file=aa_person_health.dmp" Location: Command Line, Replaced with: "dumpfile=aa_person_health.dmp"

Legacy Mode Parameter: "log=aa_person_health.log" Location: Command Line, Replaced with: "logfile=aa_person_health.log"

Legacy Mode has set reuse_dumpfiles=true parameter.

?? "Uxx"."SYS_EXPORT_TABLE_02":  uxx/******** directory=full_dir dumpfile=aa_person_health.dmp logfile=aa_person_health.log tables=aa_person_health reuse_dumpfiles=true

???? BLOCKS ??????...

?????? TABLE_EXPORT/TABLE/TABLE_DATA

?? BLOCKS ??????: 129.2 MB

?????? TABLE_EXPORT/TABLE/TABLE

?????? TABLE_EXPORT/TABLE/INDEX/INDEX

?????? TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

?????? TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

. . ??? "UXX"."AA_PERSON_HEALTH"                118.0 MB  105406 ?

?????/????? "UXX"."SYS_EXPORT_TABLE_02"

******************************************************************************

U510322.SYS_EXPORT_TABLE_02 ???????:

/backup/aa_person_health.dmp

?? "U510322"."SYS_EXPORT_TABLE_02" ?? 10:26:33 ????

[oracle@server2 ~]$ impdp uu/123 directory=full_dir file=aa_person_health.dmp log=aa_person_health.log remap_schema=uxx:uu

Import: Release 11.2.0.1.0 - Production on Tue Dec 20 10:28:56 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

Legacy Mode Active due to the following parameters:

Legacy Mode Parameter: "file=aa_person_health.dmp" Location: Command Line, Replaced with: "dumpfile=aa_person_health.dmp"

Legacy Mode Parameter: "log=aa_person_health.log" Location: Command Line, Replaced with: "logfile=aa_person_health.log"

?????/????? "UU"."SYS_IMPORT_FULL_01"

?? "UU"."SYS_IMPORT_FULL_01":  uu/******** directory=full_dir dumpfile=aa_person_health.dmp logfile=aa_person_health.log remap_schema=uxx:uu

?????? TABLE_EXPORT/TABLE/TABLE

?????? TABLE_EXPORT/TABLE/TABLE_DATA

导到这已经很长时间了,下面是这张表创建的脚本.

CREATE TABLE AA_PERSON_HEALTH(  ID                     RAW(16),  ENCOUNTER_ID           RAW(16),  PERSON_NAME            NVARCHAR2(70),  HEALTH_CODE            NVARCHAR2(23),  DOCTOR_NAME            NVARCHAR2(70),  EXAMINATION_DATE       DATE,  SYMPTOM                SYS.XMLTYPE,  BODY_TEMPERATURE       FLOAT(126),  PULSE_RATE             NUMBER(20),  RESPIRATORY_RATE       NUMBER(20),  BLOOD_PRESSURE_L       NVARCHAR2(18),  BLOOD_PRESSURE_LD      NVARCHAR2(18),  BLOOD_PRESSURE_R       NVARCHAR2(18),  BLOOD_PRESSURE_RD      NVARCHAR2(18),  HEIGHT                 FLOAT(126),  WEIGHT                 FLOAT(126),  WAISTLINE              FLOAT(126),  BODY_MASS_INDEX        FLOAT(126),  HIP                    FLOAT(126),  WAIST_HIP_RATIO        FLOAT(126),  COGNITIVE_ELDERLY      NUMBER(20),  COGNITIVE_ELDERLY_DES  NVARCHAR2(255),  OLD_PERSON_FEEL        NUMBER(20),  OLD_PERSON_FEEL_DES    NVARCHAR2(255),  GENTLENESS             SYS.XMLTYPE,  KIDNEY                 SYS.XMLTYPE,  HOSPITALIZATION        SYS.XMLTYPE,  FAMILY_DISEASE         SYS.XMLTYPE,  MAJOR_DRUG_CASE        SYS.XMLTYPE,  VACCINATION_HISTORY    SYS.XMLTYPE,  HEALTH_ASSESSMENT      SYS.XMLTYPE,  HEALTH_GUI             SYS.XMLTYPE,  FACTORS                SYS.XMLTYPE,  UPDATESYNC_STATUS      INTEGER,  UPDATEDATE             DATE)