Ora-29913 Error In Executing Odciexttableopen Callout Impdp
Contents |
the oracle bug 8393456 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
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of ora-30653 this site About Us Learn more about Stack Overflow the company Business
Ora-29913 Error In Executing Odciexttablefetch Callout During Import
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask
Ora-29913 Error In Executing Odciexttableopen Callout Ora-29400 Data Cartridge Error Kup-04040
Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up https://baioradba.wordpress.com/2011/07/26/ora-29913-error-in-executing-odciexttableopen-callout/ impdp strange ora errors up vote 2 down vote favorite 1 I did an import using impdp. Afterwards I found these errors in the log file. ORA-31693: Table data object "SMTAPP"."XP_ENTITIES_CONFIGS" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error ORA-26065: check constraint cannot reference column, SYS_NC00005$, in direct path load The http://stackoverflow.com/questions/11126602/impdp-strange-ora-errors table XP_ENTITIES_CONFIGS has an XML datatype column. The table itself was recreated successfully but the data were missing. Any idea ? oracle oracle10g share|improve this question edited Jun 20 '12 at 19:54 Alex Poole 86.9k55993 asked Jun 20 '12 at 19:15 user49126 25941636 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote accepted There are a couple of hits on Oracle Support; closest looks like bug 5574904. Bit hard to follow but possibly not fixed until 11.2. The stated workaround is to either use exp/imp instead; or to drop the constraint in the schema you've imported too (since you've said it created the table), retry the impdp with additional parameters tables=XP_ENTITIES_CONFIGS table_exists_action=append, then recreate the constraint once the data has been imported. Might well be something else though, so if in doubt raise a service request with Oracle. share|improve this answer answered Jun 20 '12 at 20:16 Alex Poole 86.9k55993 add a comment| up vote 1 down vote CHECK YOUR FILES' CHECKSUM! I had a file corruption issue moving dump files between servers. Took a long time to figure out I had
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to https://www.experts-exchange.com/questions/27663877/expdp-impdp-problem.html Get Help Ask a Question Ask for Help Receive https://community.oracle.com/thread/2337348 Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts error in Exchange > Questions > expdp/impdp problem Want to Advertise Here? Solved expdp/impdp problem Posted on 2012-04-05 Oracle Database 1 Verified Solution 4 Comments 3,073 Views Last Modified: 2012-05-08 I have a table called return_sets that exists in two different schemas (xmltest and xmltestb) with the same structures. error in executing The table in schema xmltestb contains data that includes an xmldata datatype, but is not indexed. The table in schema xmltest contains no data but has an xmlindex on the xmldata column. I tried to load the data from the xmltestb table into the xmltest table using expdp and impdp, but am getting errors. The commands I've used are: expdp xmltestb/bpword@xmldev DUMPFILE=ret_sets_data.dmp DIRECTORY=BIN_DIRECTORY TABLES=RETURN_SETS CONTENT=DATA_ONLY impdp xmltest/pword@xmldev DUMPFILE=ret_sets_data.dmp DIRECTORY=BIN_DIRECTORY TABLES=RETURN_SETS REMAP_SCHEMA=xmltestb:xmltest Execution of the expdp command completes successfully, but the impdp command shows the following error messages: Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning and Data Mining options Master table "XMLTEST"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "XMLTEST"."SYS_IMPORT_TABLE_01": xmltest/********@xmldev DUMPFILE=ret_sets_data.dmp DIRECTORY=BIN_DIRECTORY TABLES=RETURN_SETS REMAP_SCHEMA=xmltestb:xmltest Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "XMLTEST"."RETURN_SETS" failed to load/unload and is being skipped due to error: ORA-29913
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. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This 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 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 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 car