在使用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=jbjy1 Import: Release 10.2.0.1.0 - Production on Wednesday, 11 December, 2013 7:40:46 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Starting "JBTEST"."JBJY1": jbtest/******** network_link=JBZSK.REGRESS.RDBMS.DEV.US.ORACLE.COM schemas=jb remap_schema=jb:jbtest job_name=jbjy1 Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 22.62 GB Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:"JBTEST" already exists Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM ORA-31684: Object type SYNONYM:"JBTEST"."HISOPERLOG" already exists ORA-31684: Object type SYNONYM:"JBTEST"."OPERLOG" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_GL_PZML" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_GL_PZNR" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_ARRIVE_INFO" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_ASSIGN_INFO" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_BASE_INFO" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_FEE_INFO" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_INSR_INFO" already exists Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC ORA-31684: Object type TYPE:"JBTEST"."TY_STR_SPLIT" already exists Processing object type SCHEMA_EXPORT/DB_LINK ORA-31684: Object type DB_LINK:"JBTEST"."CAIWU" already exists ORA-31684: Object type DB_LINK:"JBTEST"."CAIWU.REGRESS.RDBMS.DEV.US.ORACLE.COM" already exists ORA-31684: Object type DB_LINK:"JBTEST"."JBCSK" already exists ORA-31684: Object type DB_LINK:"JBTEST"."JBCSK.REGRESS.RDBMS.DEV.US.ORACLE.COM" already exists ORA-31684: Object type DB_LINK:"JBTEST"."JBTEST" already exists Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE ORA-31684: Object type SEQUENCE:"JBTEST"."OFS_ID_SEQ" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AAE062" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AAE064" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AAE911" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AB01_DUAN" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AC01_DUAN" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAB001" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAC001" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAC021" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_ICKH" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_CC02_ACC020" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_CC03_ACC030" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_BILLNO" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_HOSPITEM" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_ICKH" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_PAYNO" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_RECIPENO" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_LOCALDB_UPDATE_NO" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_SYS" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_TRANSNO" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDD_OP_SEQ" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDJ_JOB_ID_SEQ" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDJ_JOB_OUTPUT_SEQ" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDM_PAGING_CRR_ID_SEQ" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDM_SEQUENCE_NUM" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDS_SESSIONS_SEQUENCE" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDU_OBJECTS_SEQUENCE" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDU_PRINCIPALS_SEQUENCE" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SQE_GS01_XH" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SQE_GS02_XH" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SQE_TESTNO" already exists Processing object type SCHEMA_EXPORT/TABLE/TABLE ORA-39064: unable to write to the log file ORA-29285: file write error ORA-39064: unable to write to the log file ORA-29285: file write error Job "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=y Import: Release 10.2.0.1.0 - Production on Wednesday, 11 December, 2013 7:57:14 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Starting "JBTEST"."JBTEST": jbtest/******** network_link=JBZSK.REGRESS.RDBMS.DEV.US.ORACLE.COM schemas=sy02 remap_schema=jb:jbtest job_name=jbtest nologfile=y Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 22.62 GB Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:"SYTEST" already exists Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM ORA-31684: Object type SYNONYM:"JBTEST"."HISOPERLOG" already exists ORA-31684: Object type SYNONYM:"JBTEST"."OPERLOG" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_GL_PZML" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_GL_PZNR" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_ARRIVE_INFO" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_ASSIGN_INFO" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_BASE_INFO" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_FEE_INFO" already exists ORA-31684: Object type SYNONYM:"JBTEST"."SYN_IF_CORP_INSR_INFO" already exists Processing object type SCHEMA_EXPORT/DB_LINK ORA-31684: Object type DB_LINK:"JBTEST"."CAIWU" already exists ORA-31684: Object type DB_LINK:"JBTEST"."DB_SHENGTING" already exists Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE ORA-31684: Object type SEQUENCE:"JBTEST"."OFS_ID_SEQ" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AAE062" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AAE064" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AB01_DUAN" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_AC01_DUAN" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAB001" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAC001" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_AAC021" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_A_ICKH" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_CC02_ACC020" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_CC03_ACC030" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_BILLNO" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_HOSPITEM" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_ICKH" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_PAYNO" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_K_RECIPENO" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_LOCALDB_UPDATE_NO" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_SYS" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_SYS_SY" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SEQ_TRANSNO" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDD_OP_SEQ" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDJ_JOB_ID_SEQ" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDJ_JOB_OUTPUT_SEQ" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDM_PAGING_CRR_ID_SEQ" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDM_SEQUENCE_NUM" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDS_SESSIONS_SEQUENCE" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDU_OBJECTS_SEQUENCE" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SMP_VDU_PRINCIPALS_SEQUENCE" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SQE_GS01_XH" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SQE_GS02_XH" already exists ORA-31684: Object type SEQUENCE:"JBTEST"."SQE_TESTNO" already exists Processing object type SCHEMA_EXPORT/TABLE/TABLE . . imported "JBTEST"."AC13" 18879318 rows . . imported "JBTEST"."JC01" 8791169 rows