在使用impdp通过network_link方式从一个数据库中直接导入数据到另一个数据库中在导入第一个用户正常,在导入第二个用户时报错ora-39064,ora-29285故障,检查发现这里不存在没有权限,空间不足的问题

[oracle@localhost ~]$ impdp jbtest/jbtest network_link=JBZSK.REGRESS.RDBMS.DEV.US.ORACLE.COM schemas=jb  remap_schema=jb:jbtest job_name=jbjy1Import: Release 10.2.0.1.0 - Production on Wednesday, 11 December, 2013 7:40:46Copyright (c) 2003, 2005, Oracle.  All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsStarting "JBTEST"."JBJY1":  jbtest/******** network_link=JBZSK.REGRESS.RDBMS.DEV.US.ORACLE.COM schemas=jb remap_schema=jb:jbtest job_name=jbjy1Estimate in progress using BLOCKS method...Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 22.62 GBProcessing object type SCHEMA_EXPORT/USERORA-31684: Object type USER:"JBTEST" already existsProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/SYNONYM/SYNONYMORA-31684: Object type SYNONYM:"JBTEST"."HISOPERLOG" already existsORA-31684: Object type SYNONYM:"JBTEST"."OPERLOG" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_GL_PZML" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_GL_PZNR" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_ARRIVE_INFO" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_ASSIGN_INFO" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_BASE_INFO" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_FEE_INFO" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_INSR_INFO" already existsProcessing object type SCHEMA_EXPORT/TYPE/TYPE_SPECORA-31684: Object type TYPE:"JBTEST"."TY_STR_SPLIT" already existsProcessing object type SCHEMA_EXPORT/DB_LINKORA-31684: Object type DB_LINK:"JBTEST"."CAIWU" already existsORA-31684: Object type DB_LINK:"JBTEST"."CAIWU.REGRESS.RDBMS.DEV.US.ORACLE.COM" already existsORA-31684: Object type DB_LINK:"JBTEST"."JBCSK" already existsORA-31684: Object type DB_LINK:"JBTEST"."JBCSK.REGRESS.RDBMS.DEV.US.ORACLE.COM" already existsORA-31684: Object type DB_LINK:"JBTEST"."JBTEST" already existsProcessing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCEORA-31684: Object type SEQUENCE:"JBTEST"."OFS_ID_SEQ" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AAE062" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AAE064" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AAE911" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AB01_DUAN" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AC01_DUAN" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAB001" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAC001" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAC021" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_ICKH" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_CC02_ACC020" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_CC03_ACC030" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_BILLNO" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_HOSPITEM" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_ICKH" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_PAYNO" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_RECIPENO" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_LOCALDB_UPDATE_NO" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_SYS" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_TRANSNO" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDD_OP_SEQ" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDJ_JOB_ID_SEQ" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDJ_JOB_OUTPUT_SEQ" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDM_PAGING_CRR_ID_SEQ" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDM_SEQUENCE_NUM" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDS_SESSIONS_SEQUENCE" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDU_OBJECTS_SEQUENCE" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDU_PRINCIPALS_SEQUENCE" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SQE_GS01_XH" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SQE_GS02_XH" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SQE_TESTNO" already existsProcessing object type SCHEMA_EXPORT/TABLE/TABLEORA-39064: unable to write to the log fileORA-29285: file write errorORA-39064: unable to write to the log fileORA-29285: file write errorJob "JBTEST"."JBJY1" stopped due to fatal error at 07:41:17

加入nologfile=y参数可以解决这个问题.

[oracle@localhost ~]$ impdp jbtest/jbtest network_link=JBZSK.REGRESS.RDBMS.DEV.US.ORACLE.COM schemas=sy02 remap_schema=jb:jbtest job_name=jbtest nologfile=yImport: Release 10.2.0.1.0 - Production on Wednesday, 11 December, 2013 7:57:14Copyright (c) 2003, 2005, Oracle.  All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsStarting "JBTEST"."JBTEST":  jbtest/******** network_link=JBZSK.REGRESS.RDBMS.DEV.US.ORACLE.COM schemas=sy02 remap_schema=jb:jbtest job_name=jbtest nologfile=yEstimate in progress using BLOCKS method...Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 22.62  GBProcessing object type SCHEMA_EXPORT/USERORA-31684: Object type USER:"SYTEST" already existsProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/SYNONYM/SYNONYMORA-31684: Object type SYNONYM:"JBTEST"."HISOPERLOG" already existsORA-31684: Object type SYNONYM:"JBTEST"."OPERLOG" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_GL_PZML" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_GL_PZNR" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_ARRIVE_INFO" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_ASSIGN_INFO" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_BASE_INFO" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_FEE_INFO" already existsORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_INSR_INFO" already existsProcessing object type SCHEMA_EXPORT/DB_LINKORA-31684: Object type DB_LINK:"JBTEST"."CAIWU" already existsORA-31684: Object type DB_LINK:"JBTEST"."DB_SHENGTING" already existsProcessing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCEORA-31684: Object type SEQUENCE:"JBTEST"."OFS_ID_SEQ" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AAE062" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AAE064" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AB01_DUAN" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AC01_DUAN" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAB001" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAC001" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAC021" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_ICKH" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_CC02_ACC020" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_CC03_ACC030" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_BILLNO" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_HOSPITEM" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_ICKH" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_PAYNO" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_RECIPENO" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_LOCALDB_UPDATE_NO" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_SYS" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_SYS_SY" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_TRANSNO" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDD_OP_SEQ" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDJ_JOB_ID_SEQ" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDJ_JOB_OUTPUT_SEQ" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDM_PAGING_CRR_ID_SEQ" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDM_SEQUENCE_NUM" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDS_SESSIONS_SEQUENCE" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDU_OBJECTS_SEQUENCE" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDU_PRINCIPALS_SEQUENCE" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SQE_GS01_XH" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SQE_GS02_XH" already existsORA-31684: Object type SEQUENCE:"JBTEST"."SQE_TESTNO" already existsProcessing object type SCHEMA_EXPORT/TABLE/TABLE. . imported "JBTEST"."AC13"                            18879318 rows. . imported "JBTEST"."JC01"                            8791169 rows

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26015009/viewspace-1062957/，如需转载，请注明出处，否则将追究法律责任。