Oracle Error Ora-02091
Contents |
Library mySQL Code
Ora-2091
Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-02091 Error Description: Transaction rolled back Error Cause: Also see error 2092. If the transaction is aborted at a remote site then you will only see 2091; if aborted at host then you will see 2092 and 2091. Action: Add rollback segment and retry the transaction. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 76 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
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 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask 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 Is it possible to have a “deferred check constraint” in Oracle? up vote 0 down http://psoug.org/oraerror/ORA-02091.htm vote favorite I was thinking that I'd like to have a "deferred check constraint" in Postgres, but that is apparently not supported at this time (Postgres 9.3) Then I saw that Oracle seems to broadly have "deferred" for its constraints, documented here. Therefore, is it true that Oracle 10g+ supports having a "deferred check constraint"? I might have missed further documentation to the contrary, so I figured to ask here http://stackoverflow.com/questions/21784012/is-it-possible-to-have-a-deferred-check-constraint-in-oracle as a double-check, trusting that there are people who actively use Oracle who would know the answer - thus avoiding trial-and-error, wasted hours messing around with Oracle servers. oracle constraints check-constraint share|improve this question asked Feb 14 '14 at 16:06 starlocke 1,4901124 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote accepted Yes, though I'm not sure why you'd want to: create table t42 (id number, constraint check_id check (id > 0) initially deferred deferrable); table T42 created. insert into t42 (id) values (-1); 1 rows inserted. commit; Error report - SQL Error: ORA-02091: transaction rolled back ORA-02290: check constraint (STACKOVERFLOW.CHECK_ID) violated 02091. 00000 - "transaction rolled back" *Cause: Also see error 2092. If the transaction is aborted at a remote site then you will only see 2091; if aborted at host then you will see 2092 and 2091. *Action: Add rollback segment and retry the transaction. You can update it before committing of course: insert into t42 (id) values (-1); 1 rows inserted. update t42 set id = 1 where id = -1; 1 rows updated. commit; committed. ... but I'm not sure why you would put the invalid value in the table in the first place if you planned to update it. Pr
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books http://www.dba-oracle.com/t_ora_02291_integrity_constraint_string_string_violated_parent_key_not_found.htm Oracle Scripts Ion Excel-DB Don Burleson Blog https://support.software.dell.com/kb/49584
ORA-02291: integrity constraint violated-parent key not found tips Oracle Error Tips by Burleson Consulting (S. Karam) The Oracle docs note this on the ora-02291 error: ORA-02291: integrity constraint (string.string) violated - parent key not oracle error found Cause: A foreign key value has no matching primary key value. Action: Delete the foreign key or add a matching primary key. For an insert statement, this ORA-02291 error is common when you are trying to insert a child without a matching parent, as defined by a foreign key constraint. In that case, you need oracle error ora-02091 to add the parent row to the table and then re-insert your child table row.See the dba_constraints view to find the parent table.To fully understand [primary and foreign key constraints, see the book Easy Oracle Jumpstart, to explain these concepts: Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. Burleson Consulting The Oracle of Database Support Oracle Performance Tuning RSonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that you have registered your product at My SonicWALL . If you have already registered your product then please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue × Support Forms Under Maintenance Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience. Continue Search Sign In Sign In Create Support Account Products ActiveRoles Boomi Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development and Management Database Replication & Backup Endpoint Management Mobile Workforce Management Overview Desktop Virtualization Enterprise Mobility Management Endpoint Security Network Security Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My Profile Policies & Procedures Professional Services Technical Documentation Training & Certification User Forums Video Tutorials Support Home Communities Partners × Email Share your favorite Support content with a friend. Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information For more information regarding support on your Dell Software Product, please visit www.software.dell.com/support Print Email My Downloads () Support Knowledge Base SharePlex for OracleNT Post process stops due to "ORA-02091 and ORA-00001" (49584) × Return Feedback submitted. Was th