Ora-29913 Error In Executing Odciexttablefetch Callout During Import
Contents |
the ora-31693 ora-29913 ora-02291 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
backup using expdp ( RAC / Non-RAC) ~ Applied to: Oracle 10g/11g About Document:Some times management asks to create pre-prod database environment to oracle bug 8393456 test some scenarios/ to train users / patch movement. But prod and ora-31693 ora-29913 ora-02291 impdp UAT/ Pre-PROD may not be same platform. So that you can't restore from RMAN backup ( ENDIAN_FORMAT should ora-31693: table data object failed to load/unload and is being skipped due to error support. Check using v$transportable_platform view). So you have choice to restore using EXPDP ( logical backup). Then you need a consistent backup to restore. So using EXPDP you can https://baioradba.wordpress.com/2011/07/26/ora-29913-error-in-executing-odciexttableopen-callout/ take backup upto a snap shot time ( SCN), you can follow the below method: Note: You can use Oracle golden gate to migrate database across platform. Other third party tools can be used also. expdp full=y directory=DATA_PUMP dumpfile=oraprod_full.dmp logfile=oraprod_full_exp.log exclude=statistics FLASHBACK_SCN=25330457434 COMPRESSION=ALL -- To find FLASHBACK_SCN sql> select name,current_scn from v$database; Note: COMPRESSION=ALL can be used to take compressed http://facedba.blogspot.com/2013/10/export-or-import-taking-consistent.html backup. Same can be ignore. This is 11g new feature. -- Find currently export executing jobs sql> select * from dba_datapump_jobs where state='EXECUTING'; -- Current Status of export /import sql> select sid,serial#,sofar,totalwork,start_time, sysdate,time_remaining,message from v$session_longops where opname like '%IMPORT%'; Sample output: Note: Use CLUSTER=N in expdp/ impdp while exporting/importing from/to multitude RAC database. You can add PARALLEL clause to make the EXPDP/ IMPDP faster. "flashback_time" can be used for consistent backup using "expdp": Flashback_time at current time: The flashback_time=systimestamp syntax: is the current time. $ cat mybackup1.par full=y directory=data_pump dumpfile=oraprod%U.dmp logfile=oraprod_exp.log parallel=4 filesize=20G exclude=statistics flashback_time=systimestamp $ expdp parfile=mybackup.par Flashback_time at specific time: Instead of the current time, you can specify any time which is possible within flashback capabilities (undo log sizes). using the to_timestamp argument. Oracle notes that the system change number (SCN) that most closely matches the specified time is found, and this SCN is used to enable the Flashback utility. The export operation is performed with data that is consistent up to this SCN. $cat mybackup2.par full=y directory=data_pump dumpfile=oraprod%U.dmp logfile=oraprod_exp.log parallel=4 filesize=20G exclude=statistics flashback_time="to_timestamp('0
friend Import from 11g to 10g results in strange errors [message #586980] Wed, 12 June 2013 03:59 Andrey_R Messages: 216Registered: http://www.orafaq.com/forum/t/188041/ January 2012 Location: Euro-Asia Senior Member I wanted to migrate two https://www.experts-exchange.com/questions/27663877/expdp-impdp-problem.html schemas from: Source Database machine OS: OEL 5.9 , 64-bit Source Database version/addition: 11.2.0.1.0 SE to: Target Database machine OS: Red Hat Enterprise Linux Server release 5.4 , 64-bit Target Database version/addition: 10.2.0.4.0 EE Therefore, I did an export using Oracle Data Pump: ;;; error in Export: Release 11.2.0.1.0 - Production on Tue Jun 11 13:13:28 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. ;;; Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production Starting "SYSTEM"."SYS_EXPORT_SCHEMA_04": system/******** directory=DATA_PUMP_DIR dumpfile=exp_PRODSCHEMAS_20130611.dmp schemas=PRD_100,SHR_100 logfile=exp_PRODSCHEMAS_20130611.log VERSION=10.2.0.4.0 Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: error in executing 1.026 GB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT **** **** . . exported "PRD_100"."X1_APP_OB" 0 KB 0 rows . . exported "PRD_100"."X2_APP_OB" 0 KB 0 rows . . exported "PRD_100"."X3_APP_OB" 0 KB 0 rows . . exported "PRD_100"."X4_APP_OB" 0 KB 0 rows . . exported "PRD_100"."X5_APP_OB" 0 KB 0 rows . . exported "PRD_100"."X6_APP_OB" 0 KB 0 rows . . exported "PRD_100"."X7_APP_OB" 0 KB 0 rows . . exported "PRD_100"."X8_APP_OB" 0 KB 0 rows Master table "SYSTEM"."SYS_EXPORT_SCHEMA_04" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_04 is: /u01/app/oracle/admin/*****/dpdump/exp_PRODSCHEMAS_20130611.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_04" successfully completed at 13:15:18 and then the import, with user SYSTEM: ;;; Import: Release 10.2.0.4.0 - 64bit Production on Tuesday, 11 June, 2013 16:14:04 Copyright (c) 2003, 2007, Oracle. All rights reserved. ;;; Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** directory=EXP_DIR dumpfile=exp_PRODSCHEMAS_20130611.dmp remap_schema=PRD_100:PRD_LIVE,SHR_100:SHR_LIVE transform=segment_attributes:n,oid:n logfile=imp_PRODSCHEMAS_20130611 Processing object type SCHEMA_EXPORT/USER ORA-31684:
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 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 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. 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: 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"."S