Ora-02443 Error In Oracle
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript
Ora-02441: Cannot Drop Nonexistent Primary Key
and much of it will not work correctly oracle drop constraint drop index without it enabled. Please turn JavaScript back on and reload this page.
How To Drop Unique Index In Oracle
Please enter a title. You can not post a blank message. Please type your message and try again. More ora 2443 discussions in Streams All PlacesDatabasePerformance & AvailabilityStreams This discussion is archived 0 Replies Latest reply on Aug 18, 2015 2:59 AM by 1538024 ORA-02443 Cannot drop constraint - nonexistent constraint 1538024 Aug 18, 2015 2:59 AM Streaming generated error ora-00955: name is already used by an existing object in oracle because of the different constraint name between source and destination db, one side dropped but the other side cannot be sync, consequently data cannot be sync due to unique constraint violation error.My question is, is there any way to sync constraint when their names are different? I have the same question Show 0 Likes(0) 617Views Tags: none (add) This content has been marked as final. Show 0 replies Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
Library mySQL Code Library PHP Code Library JavaScript
Ora-01418
Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG https://community.oracle.com/thread/3781645 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: http://psoug.org/oraerror/ORA-02443.htm ORA-02443 Error Description: Cannot drop constraint - nonexistent constraint Error Cause: Alter table drop constraint
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss http://stackoverflow.com/questions/25361410/drop-auto-generated-constraint-name 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 in oracle each other. Join them; it only takes a minute: Sign up Drop auto generated constraint name up vote 0 down vote favorite I have an auto-generated primary key constriant. The key is actually wrong. It should be against two columns and currently it is against one. I need to run this script on multiple databases and so the name is already constraint name may be different for each database. I need to get the constraint name and then drop it and then create the new primary key. here is the script I have so far DECLARE con_name VARCHAR(255); BEGIN select constraint_name into con_name from all_constraints where table_name = 'MY_TABLE' and constraint_type = 'P'; EXECUTE immediate 'ALTER TABLE MY_TABLE drop constraint con_name'; EXECUTE immediate 'ALTER TABLE MY_TABLE ADD CONSTRAINT MT_PK PRIMARY KEY (REV, ID)'; COMMIT; / EXIT; However I have a problem in that I think it is trying to drop con_name rather than the value within that variable. Error on script: Error number: -2443, Error Message: ORA-02443: Cannot drop constraint - nonexistent constraint Can anyone help? I basically need to drop the pk in this table. Is there any other way or is my approach the right sort of way. Thanks oracle oracle11g share|improve this question asked Aug 18 '14 at 10:41 RNJ 8,16194697 add a comment| 1 Answer 1 active oldest votes up vote 3 down vote accepted Your con_name var