Ora-29913 Error In Executing Odciexttableopen Callout Expdp
Contents |
the ora-30653 site owner. Once you've created an account, log in and revisit this screen to request an invite.If you already have both of these, great! Log in here: Email or Username Password Stay signed in ← Back to WordPress.com
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 of ora-29913 error in executing odciexttablefetch callout during import a schema: ORA-31693: Table data object "SH"."SALES_REG1_Q1" failed to load/unload and is being skipped due to oracle bug 8393456 error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout After some searching on the internet, I found evidence of bug 8393456, and it is indeed kup-04040 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 by https://baioradba.wordpress.com/2011/07/26/ora-29913-error-in-executing-odciexttableopen-callout/ 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 (5) ► February http://minimalistic-oracle.blogspot.com/2014/03/i-recently-hit-this-error-from-one-of.html (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 rec... How to backup your controlf
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 https://community.oracle.com/thread/2337348 it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type http://www.acehints.com/2012/11/oracle-11gr2-impdp-dataoptions.html your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 2 Replies Latest reply on error in 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 named XMA & REPOSITORY on 10gRel2 database instance named IMRDEV. I need to clone them to another database instance named IMRDEV2. I am using EXPDP error in executing 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 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 executin
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 a