oracle impdp network_link直接导入数据报ora-39064 ora-29285

在使用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

Leave a Reply

Your email address will not be published.

Proudly powered by WordPress | Indrajeet by Sus Hill.