Data Pump Ora-29913 Error In Executing Odciexttableopen Callout
Contents |
12C Exadata Golden Gate Cassandra MariaDB baironnie 9:13 ora 20011 approximate ndv failed ora 29913 error in executing odciexttableopen callout am on July 26, 2011 Tags: impdp error, ORA-29913, ora 29913 error in executing odciexttablefetch callout ora 30653 reject limit reached oracle datapump ( 2 ) ORA-29913: error in executing ODCIEXTTABLEOPEN callout i'm doing refresh ora-29913: error in executing odciexttablepopulate callout expdp of some table from our prod. during export i did not specify the parallel option but when i do the import i specify ora-31693 ora-29913 ora-00600 parallel option. and got this error ORA-29913: error in executing ODCIEXTTABLEOPEN callout Datapump exort. Export: Release 11.1.0.7.0 - 64bit Production on Thursday, 21 July, 2011 11:12:58 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With
Ora-31693 Ora-29913 Ora-02291
the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_TABLE_02″: system/******** tables=ARADMIN.T33,ARADMIN.SERVGRP_USERLIC,ARADMIN.SERVGRP_APPLIC directory=EXPDIR logfile=t33_SERVGRP_USERLIC_SERVGRP_APPLIC dumpfile=t33_SERVGRP_USERLIC_SERVGRP_APPLIC Estimate in progress using BLOCKS method… Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 12.10 GB Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS . . exported "ARADMIN"."T33″ 10.29 GB 39592574 rows . . exported "ARADMIN"."SERVGRP_USERLIC" 54.20 KB 1658 rows . . exported "ARADMIN"."SERVGRP_APPLIC" 34.16 KB 620 rows Master table "SYSTEM"."SYS_EXPORT_TABLE_02″ successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_TABLE_02 is: /db/db05/oradata/PD01RMDY/exp/t33_SERVGRP_USERLIC_SERVGRP_APPLIC.dmp Job "SYSTEM"."SYS_EXPORT_TABLE_02″ successfully completed at 11:16:58 datapump import with parallel option. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYS"."SYS_IMPORT_FULL_01″ successfully loaded/unloaded Starting "SYS"."SYS_IMPORT_FULL_01″: "/******** AS S
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
Ora-29913: Error In Executing Odciexttablefetch Callout
object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "TEST"."CI_TAB2_T" failed oracle bug 8393456 to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEOPEN ora-31693 ora-29913 ora-01555 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 https://baioradba.wordpress.com/2011/07/26/ora-29913-error-in-executing-odciexttableopen-callout/ data object "TEST"."CI_TAB2_T" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout 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 http://amitksri14.blogspot.com/2015/01/impdp-error-ora-29913-error-in.html 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 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... F
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will https://community.oracle.com/thread/2337348 not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not http://philsumner.blogspot.com/2014/07/data-pump-ora-39786-number-of-columns.html post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This error in discussion 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 named XMA & REPOSITORY on 10gRel2 database instance named IMRDEV. I need to error in executing 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 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
Chiefly working with Oracle 11gR2 & OEM 12c with a little bit of 10g thrown in on the side. Data pump - "ORA-39786: Number of columns does not match between export and import databases" Today I was asked if it was possible to import data for a specific table from a data pump export file, which was taken from when a table had a different structure to what it has now. e.g. when the export was taken, there were 10 columns. Now there are 11. I thought that was simple, and I was sure I'd heard of this being done before. Simply import using the "CONTENT=DATA_ONLY" parameter. Right? Apparently not: Centos-/home/oracle/demo> impdp DEMO_USER/yyyyyyy directory=INBOUND dumpfile=demo_data.dmp logfile=impdpdemo.log content=data_only tables=xxxxxxxxImport: Release 10.2.0.4.0 - 64bit Production on Tuesday, 08 July, 2014 14:32:20Copyright (c) 2003, 2007, Oracle. All rights reserved.Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit ProductionMaster table "DEMO_USER"."SYS_IMPORT_TABLE_01" successfully loaded/unloadedStarting "DEMO_USER"."SYS_IMPORT_TABLE_01": xxxxxxxx/******** directory=INBOUND dumpfile=demo_data.dmp logfile=impdpdemo_log content=data_only tables=xxxxxxxxxProcessing object type SCHEMA_EXPORT/TABLE/TABLE_DATAORA-31693: Table data object "DEMO_USER"."xxxxxxxxxxx" failed to load/unload and is being skipped due to error:ORA-29913: error in executing ODCIEXTTABLEOPEN calloutORA-29400: data cartridge errorORA-39786: Number of columns does not match between export and import databasesJob "DEMO_USER"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 14:32:22 A spot of googling and checking My Oracle Support led me to this note: 435193.1. Turns out that if data pump chooses to use the "External Tables" method of importing, this won't work because the table it's importing from has different number of columns - it's not doing a straight insert. Reasons why data pump will choose the "External Tables" method of importing are documented here (these are 11.2 docs - I know I'm using 10.2 here - http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL805) but I'll list them below for reference: If any of the following conditions exist for a table, then Data Pump uses external tables rather than direct path to load the data