Ora-31693 Ora-29913 Error In Executing Odciexttableopen Callout
Contents |
is to provide simple examples, so that they can be easily adapted to other situations. Thursday, March 6, 2014 How
Ora-29913 Error In Executing Odciexttableopen Callout During Impdp
to deal with impdp error ORA-29913: error in executing ODCIEXTTABLEOPEN callout ora-29913 error in executing odciexttableopen callout expdp I recently hit this error from one of my customers during import of a schema: ORA-31693:
Ora-29913: Error In Executing Odciexttablepopulate Callout Expdp
Table data object "SH"."SALES_REG1_Q1" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout After some searching on the internet, I ora-31693 ora-29913 ora-02291 found evidence of bug 8393456, and it is indeed 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 setting PARALLEL=1 and I can confirm ora-31693 ora-29913 ora-00600 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 (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
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 this site About Us Learn more about Stack Overflow the company Business Learn
Odciexttablefetch
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags ora-30653 Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you,
Oracle Bug 8393456
helping each other. Join them; it only takes a minute: Sign up 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. http://minimalistic-oracle.blogspot.com/2014/03/i-recently-hit-this-error-from-one-of.html 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 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 http://stackoverflow.com/questions/11126602/impdp-strange-ora-errors 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 corrupted a file. share|improve this answer answered Jun 6 '13 at 19:24 James 111 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse ot
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 object type TABLE_EXPORT/TABLE/TABLE_DATA http://amitksri14.blogspot.com/2015/01/impdp-error-ora-29913-error-in.html ORA-31693: Table data object "TEST"."CI_TAB2_T" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout . . imported http://www.orafaq.com/forum/t/182596/ "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 data object "TEST"."CI_TAB2_T" failed to load/unload error in 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 PARALLEL (>1) and REMAP_SCHEMA at the same time. Oracle error in executing 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... Failed to establish dependency between database DB... GOLDEN GATE SETUP - DML/DDL Golden Gate Setup on ASM Golden
Fri, 06 July 2012 10:13 chandu208 Messages: 17Registered: July 2012 Junior Member while i'm importing schemas i came accross ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-02291: integrity constraint (STATICO.FK_PROD_REQ_LIS_TAG_GEN_2) violated - parent key not found ORA-31693: Table data object "STATICO"."PROD_REQ_LIS_TAG_GEN":"GEN_DS_LOAN" failed to load/unload and is being skipped due to error: any sugessions? Report message to a moderator Re: Error During IMPDP [message #559825 is a reply to message #559822] Fri, 06 July 2012 10:29 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member >ORA-02291: integrity constraint (STATICO.FK_PROD_REQ_LIS_TAG_GEN_2) violated - parent key not found don't import orphan records. Please read and follow the forum guidelines, to enable us to help you: http://www.orafaq.com/forum/t/88153/0/ Report message to a moderator Re: Error During IMPDP [message #559827 is a reply to message #559822] Fri, 06 July 2012 10:35 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator What don't you understand in the message? Either remove the contraint or the offending data. Regards Michel Report message to a moderator Previous Topic: datapump Exclude Parameter Next Topic: Schema level export with particular partition tables Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- OtherGeneralTraining & CertificationMarketplaceCommunity HangoutSuggestions & FeedbackTest- Non-English ForumsArabicDutchFrenchGermanJapanesePortugueseRussianSpanish -=] Back to Top [=- [ Syndicate this forum (XML) ] [ ] Current Time: Sun Oct 23 11:37:47 CDT 2016 Total time taken to generate the page: 0.03924 seconds .:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.