Ora-29913 Error In Executing Odciexttablefetch Callout Xml
Contents |
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a ora-29913 error in executing odciexttablefetch callout during import Freelance Project Hire for a Full Time Job Ways to Get Help
Ora-30653: Reject Limit Reached
Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing ora 29913 error in executing odciexttableopen callout ora 29400 data cartridge error Store Headlines Experts 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
Ora-29400 Data Cartridge Error Kup-04040
Modified: 2012-05-08 I have a table called return_sets that exists in two different schemas (xmltest and xmltestb) with the same structures. 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 ora-29400 data cartridge error error opening file 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: error in executing ODCIEXTTABLEFETCH callout ORA-29875: failed in the execution of the ODCIINDEXINSERT routine ORA-00600: internal error code, arguments: [kglslod:subheap], [8], [0x3E1D712E8], [], [], [], [], [], [], [], [], [] Job "XMLTEST"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 09:47:03 The error message documentation below doesn't seem to provide too much help in resolving the problem. ORA-31693: Table data object string failed to load/unload and is being skipped due to error: string Cause: Table failed to load or unload du
Oracle 10g [message #461099] Wed, 16 June 2010 09:53 oracle149 Messages: 1Registered: June 2010 Junior Member While importing a 22 GB
Impdp Ora-29913: Error In Executing Odciexttablefetch Callout
dump file ,exported from producation db without any errors, into
Oracle External Table
a local server,I am getting the following errors as per the log: opyright (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 Master table "ERRE"."SYS_IMPORT_FULL_01" successfully https://www.experts-exchange.com/questions/27663877/expdp-impdp-problem.html loaded/unloaded Starting "ERRE"."SYS_IMPORT_FULL_01": 'ERRE/********@ecprod' full=y remap_schema=ERRE:ERRE,essc:essc,EPPA:EPPA directory=dba_dir dumpfile=dump01.dmp LOGFILE=LOG01.LOG Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:"essc" already exists ORA-31684: Object type USER:"ERRE" already exists ORA-31684: Object type USER:"EPPA" 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 Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC http://www.orafaq.com/forum/t/158854/ Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "ERRE"."ER_PATFORMS" 19.34 GB 48582 rows . . imported "ERRE"."ER_FORMAUDITCOL" 341.6 MB 3406926 rows . . imported "ERRE"."ER_USERSESSIONLOG" 191.1 MB 636744 rows . . imported "ERRE"."ER_FORMLIBVER" 184.2 MB 292 rows ORA-31693: Table data object "ERRE"."ER_FORMLIB" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-00600: internal error code, arguments: [klxpr_03], [1], [], [], [], [], [], [] ORA-31693: Table data object "ERRE"."ER_FORMSLINEAR" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-02368: file is not valid for this load operation ORA-31693: Table data object "ERRE"."AUDIT_INSERT" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-02368: file is not valid for this load operation ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name "DW01" prematurely terminated ORA-31672: Worker process DW01 d
Oracle RAC Home About Me Books Articles & Presentations VirtaThon Public Speaking Errata Expert Oracle RAC Data Guard 6.25.2011 11gR2 upgrade aftermath - impdp failed with ORA-29913+ ORA-31011+ ORA-19202 + LPX-00217 It has been almost close to 3 months since we had a successful Oracle 10gR2 (10.2.0.4) clusterware upgrade with nearly 100 database to Oracle 11gR2 (11.2.0.2) at our site. However, ourassociationwith an unforeseenbugs and adjusting our application code (a very minimal) to confront the significant changes in the behavior with11gR2functionalityis yet to come to a happy ending . I wanna share yet another 11gR2 upgrade aftermath fairy tale (BUG) that we have come across about a few days ago. Before I start ofsummarizingwhat had happen, I must confess it indeed put me in a catch-22situationand luckily it was with the non-production RAC database, I managed to overcome from the pain. To cut the long story short, here is whathappened... In order to fix some of the application bugs that encountered with the close of business(COB) process, the development team wanted to simulate the test, thereby, requested me to take a logical backup (export) of one of the schema in a RAC database that was recently upgraded to 11gR2. The actual plan was like, performing a logical backup (export) for the schema, simulating the COB test (application) failure, dropping the schema followed by the schema restore (import). The schema contains over 35 thousand objects where every table has only two columns and one of the columns defined XMLTYPE data type. I knew it is bitunusual. Once the test was over, I dropped the schema and initiated the import just before I left home for the day. The very next morning I promptlyjumped to the bottom of the import logfile to ensure everything went smoothly. By bad, what I had seen was a bitdisappointing because the import completed with around 15 erro