Ora-29913 Error In Executing Odciexttableopen Callout Import
Contents |
is to provide simple examples, so that they can be easily adapted to other situations. Thursday, March 6, 2014 How to deal with impdp error ORA-29913: error in executing ODCIEXTTABLEOPEN callout I recently hit this error from one of my customers during import ora-29913 error in executing odciexttableopen callout during impdp of a schema: ORA-31693: Table data object "SH"."SALES_REG1_Q1" failed to load/unload and is being skipped due ora-29913: error in executing odciexttablepopulate callout expdp to error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout After some searching on the internet, I found evidence of bug 8393456, and it is
Ora-29913 Error In Executing Odciexttableopen Callout Expdp
indeed confirmed on the Oracle Support website. The problem seems to be related to cases where you use both PARALLEL (>1) and REMAP_SCHEMA at the same time. Oracle versions affected are 11.2.0.1, 11.1.0.7 and 10.2.0.4. I implemented the workaround
Ora-31693 Ora-29913 Ora-02291
by setting PARALLEL=1 and I can confirm that it solves the problem. Posted by Name: Vegard Kåsa at Thursday, March 06, 2014 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Errors, Oracle Utilities No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Blog Archive ► 2016 (40) ► October (2) ► September (2) ► August (6) ► July (5) ► June (4) ► May (1) ► April (4) ► March ora-31693 ora-29913 ora-00600 (5) ► February (5) ► January (6) ► 2015 (68) ► December (9) ► November (10) ► October (6) ► September (4) ► August (4) ► July (5) ► June (1) ► May (8) ► April (8) ► March (2) ► February (4) ► January (7) ▼ 2014 (135) ► December (9) ► November (4) ► October (8) ► September (3) ► August (6) ► July (7) ► June (25) ► May (12) ► April (1) ▼ March (18) What are nodeapps in an Oracle RAC environment? How to use the dbms_metadata package to generate D... How to use the dbms_metadata package to generate D... How to perform a clone from active database How to set up ssh connection between two servers f... What is the difference between "in line" and "out ... How to use the different options for DATE datatype... What are AWR and ADDM and how are they related? How to find the AWR snapshots currently available ... How to check that an Oracle database parameter is ... How to receive user response in a korn shell unix ... How to gather histograms on a column of a table How to set up an alias that quickly shows you the ... How to deal with impdp error ORA-29913: error in e... How to use v$session_longops to check long running... How to deal with RMAN-06004: ORACLE error from re
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.
Oracle Bug 8393456
Please enter a title. You can not post a blank message. Please ora-31693 ora-29913 ora-02291 impdp type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion ora-31693: table data object failed to load/unload and is being skipped due to error is archived 2 Replies Latest reply on Jan 19, 2012 1:02 PM by AnjumShehzad Cloning a schema containing AQ$_ Tables AnjumShehzad Jan 19, 2012 11:19 AM Hi, I have schemas http://minimalistic-oracle.blogspot.com/2014/03/i-recently-hit-this-error-from-one-of.html named XMA & REPOSITORY on 10gRel2 database instance named IMRDEV. I need to clone them to another database instance named IMRDEV2. I am using EXPDP and IMPDP. XMA schema contains AQ$ Queue Tables i.e. imrdev-SQL> select object_type, count(*) from dba_objects where owner='XMA' and object_name like 'AQ$_%' group by object_type order by 1; OBJECT_TYPE COUNT(*) ------------------- ---------- EVALUATION CONTEXT 3 https://community.oracle.com/thread/2337348 INDEX 38 QUEUE 22 SEQUENCE 3 TABLE 19 VIEW 50 6 rows selected. Following command was used to export the schemas: nohup expdp system/passwd@imrdev schemas=REPOSITORY,XMA directory=EXPDP_DIR dumpfile=expdp_repository_xma_19Jan12.dmp logfile=expdp_repository_xma_19Jan12.log & Following command was used to import the schemas: nohup impdp system/passwd@imrdev2 directory=EXPDP_DIR dumpfile=expdp_repository_xma_19Jan12.dmp logfile=impdp_repository_xma_19Jan12.log & I see following errors in my log... ... ORA-31693: Table data object "XMA"."TBL_EACC_SPG_FA_REQ" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error ORA-39779: type "SYS"."AQ$_JMS_TEXT_MESSAGE" not found or conversion to latest version is not possible ORA-31693: Table data object "XMA"."XMA_7_IN_QT" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error ORA-39779: type "SYS"."AQ$_JMS_TEXT_MESSAGE" not found or conversion to latest version is not possible ORA-31693: Table data object "XMA"."TBL_EACC_WO_REQ" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ... I want to know what is the best way to clone schemas containing Oracle AQ stuff... regards, -- Anjum 2697Views Tags: none (add) aqContent tagged with aq
AS SYSDBA dumpfile=exp_DC_OCM_2tbs_29Jan2015_1150_%U.dmp directory=DATAPUMP_DIR3 logfile=imp_exp_DC_OCM_2tbs_29Jan2015_1150.log table_exists_action=replace remap_schema=test:test parallel=24 Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "TEST"."CI_TAB2_T" failed http://amitksri14.blogspot.com/2015/01/impdp-error-ora-29913-error-in.html to load/unload and is being skipped due to error: ORA-29913: error http://www.acehints.com/2012/11/oracle-11gr2-impdp-dataoptions.html in executing ODCIEXTTABLEOPEN callout . . imported "TEST"."CI_TAB1_K_T" 5.003 MB 1241230 rows Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "SYS"."SYS_IMPORT_FULL_02" completed with 1 error(s) at 12:04:50 ORA-31693: Table data object "TEST"."CI_TAB2_T" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout error in This is because of bug 8393456, and same can be confirmed on the Oracle Support website. The problem seems to be related to cases where you use both PARALLEL (>1) and REMAP_SCHEMA at the same time. Oracle versions affected are 11.2.0.1, 11.1.0.7 and 10.2.0.4. Workaroundimplementedby setting PARALLEL=1 (even you can user remap_schema) clause Solution: Do not user error in executing PARALLEL >1 with REMAP_SCHEMA clause in datapump (impdp). Posted by Amit Kumar Srivastava (Oracle 11g Certified Master - OCM11g) at 10:35 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Total Pageviews About Me Amit Kumar Srivastava (Oracle 11g Certified Master - OCM11g) Oracle 11g Certified Masters (OCM) having Sound Expertise in (Exadata,Golden Gate, RAC,Dataguard, RMAN, Performance Tuning, Warehouse, Encryption,Audit and DB Security, Wallet ....etc View my complete profile Blog Archive ▼ 2015 (24) ► July (4) ► June (2) ► February (8) ▼ January (10) impdp: error ORA-29913: error in executing ODCIEXT... Failed to establish dependency between database DB... GOLDEN GATE SETUP - DML/DDL Golden Gate Setup on ASM Golden Gate: ERROR OGG-01224 Address already in u... opiodr aborting process unknown ospid as a result ... OCSSD starts if voting disk & OCR resides in ASM D... Oracle Kernel RAC: ON and OFF GoldenGate - Error ORA-20782 while deleting Golden... Golden
import. You have to invoke it specifically to handle some special kind of data during the import operations. There are 2 options for this parameter. DATA_OPTIONS = [DISABLE_APPEND_HINT | SKIP_CONSTRAINT_ERRORS] Value 1: DISABLE_APPEND_HINT This vale tells the impdp not to use the APPEND hint during the import operation. By default APPEND hint will be enabled in impdp. If you disable this hint by using this option will help you to access the importing tables by other sessions concurrently. Value 2: SKIP_CONSTRAINT_ERRORS This page I wanted to elaborate more on this parameter value SKIP_CONSTRAINT_ERRORS. In normal case the impdp utility will rollback the entire table import in case any constraint error encounters on that particular table. If you use SKIP_CONSTRAINT_ERRORS as the parameter value, it will tell the import operation to continue even there is constraint errors for some records. It will import the records which satisfies the constraints. See example for more details. I have a table called EMP with 12 number of records. SQL> select count(*) from emp; COUNT(*) ---------- 12 Adding a unique constraint to the table SQL> alter table emp add constraint emp_ename unique(ename) ; Table altered. I have taken the export of this table and I deleting 2 records from that. SQL> delete from emp where rownum<3; 2 rows deleted. SQL> commit; Commit complete. Importing the dump with table_exists_action=append. This operation is getting failed with constraint error. It will not insert any of the rows from the export dump. It will rollback the entire table import operation. $ impdp job_name=schemaexp1 full=y dumpfile=exp_emp.dmp logfile=imp_exp_emp.log directory=EXP_DIR table_exists_action=append Import: Release 11.2.0.2.0 - Production on Wed Nov 7 02:22:58 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: / as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Master table "SYS"."SCHEMAEXP1" successfully loaded/unloaded Starting "SYS"."SCHEMAEXP1": /******** AS SYSDBA job_name=schemaexp1 full=y dumpfile=exp_emp.dmp logfile=imp_exp_emp.log directory=EXP_DIR table_exists_action=append Processing object type TABLE_EXPORT/TABLE/TABLE Table "SCOTT"."EMP" exists. Data will be appended to exi