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
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26015009/viewspace-1062957/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle資料泵匯出匯入（expdp/impdp）Oracle
- 關於impdp匯入資料的network_link的使用介紹
- Impdp資料泵匯入
- Oracle使用資料泵expdp,impdp進行資料匯出匯入Oracle
- 使用impdp network link 跳過expdp直接匯入資料
- impdp/expdp報錯: ORA-39064: 無法寫入日誌檔案 ORA-29285: 檔案寫入錯誤
- 使用資料泵impdp匯入資料
- Oracle expdp/impdp匯出匯入命令及資料庫備份Oracle資料庫
- Oracle expdp/impdp匯入匯出備份資料庫指令碼Oracle資料庫指令碼
- Oracle使用impdp的network_link遷移資料庫Oracle資料庫
- IMPDP匯入遠端資料庫資料庫
- oracle匯入匯出之expdp/impdpOracle
- 資料庫泵（expdp/impdp）匯入匯出流程資料庫
- Oracle 11g impdp 先資料後索引匯入方法Oracle索引
- Oracle 19.3資料庫impdp匯入view時hang住Oracle資料庫View
- Oracle 28.6資料庫impdp匯入view時hang@11Oracle資料庫View
- Oracle IMPDP匯入資料案例之注意事項（undo/temp）Oracle
- 資料泵IMPDP 匯入工具的使用
- expdp impdp 資料庫匯入匯出命令詳解資料庫
- 將SQLServer表直接匯入Oracle資料庫（圖文教程）SQLServerOracle資料庫
- c#直接呼叫ssis包實現Sql Server的資料匯入功能C#SQLServer
- 然後再全庫匯入排除view資料庫在impdp匯入View資料庫
- impdp匯入資料後,system 表空間整理
- 通過EXPDP/IMPDP匯出匯入遠端資料倒本地
- Oracle 資料匯入匯出Oracle
- Oracle資料匯入匯出Oracle
- Oracle 12.1.0.2 impdp匯入慢診斷Oracle
- 使用EXPDP/IMPDP匯入匯出表中資料/後設資料測試
- 【IMPDP】使用IMPDP自動建立使用者並完成資料的匯入
- Oracle 12c expdp和impdp匯出匯入表Oracle
- oracle10g expdp資料泵的bug,按schema匯出，匯入impdp時無jobOracle
- oracle impdp network_link引數使用介紹Oracle
- 用impdp匯入資料的一次經歷
- rac環境下使用impdp匯入資料出錯
- impdp 匯入 指令碼指令碼
- 【EXPDP/IMPDP】使用 EXPDP/IMPDP工具“模糊”匯出和匯入
- impdp做資料匯入時約束和觸發器引起資料匯入後應用故障觸發器
- Oracle 資料匯入ExcelOracleExcel