ORA-02275: such a referential constraint already exists in the table

Cause : Self-eivdent.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Removet he extar constarint.

update : 23-08-2017
ORA-02275

ORA-02275 - such a referential constraint already exists in the table
ORA-02275 - such a referential constraint already exists in the table

  • ora-19816 : WARNING: Files may exist in string that are not known to database.
  • ora-27474 : cannot give both an argument name and an argument position
  • ora-37118 : The OLAP API library was not preloaded.
  • ora-34901 : (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.
  • ora-06503 : PL/SQL: Function returned without value
  • ora-27028 : skgfqcre: sbtbackup returned error
  • ora-24900 : invalid or unsupported mode paramater passed in call
  • ora-07746 : slemrd: invalid error message file handle
  • ora-01166 : file number string is larger than string (string)
  • ora-01209 : data file is from before the last RESETLOGS
  • ora-15048 : ASM internal files cannot be deleted
  • ora-29539 : Java system classes already installed
  • ora-06761 : TLI Driver: error sending orderly release
  • ora-29848 : error occurred in the execution of ODCIINDEXMERGEPARTITION routine
  • ora-14278 : column type or size mismatch in EXCHANGE SUBPARTITION
  • ora-12479 : file label string must equal DBHIGH string
  • ora-24002 : QUEUE_TABLE string does not exist
  • ora-19275 : XP0055 - schema path string not found in list of in-scope schema definitions
  • ora-06024 : NETASY: VTM error
  • ora-12464 : invalid characters in label component string
  • ora-01119 : error in creating database file 'string'
  • ora-09826 : SCLIN: cannot initialize atomic latch.
  • ora-02208 : duplicate MAXTRANS option specification
  • ora-07215 : slsget: getrusage error.
  • ora-06443 : ssvpstev: Incorrect parameter passed to function call
  • ora-03248 : Too much of segment creation activity during migration
  • ora-31696 : unable to export/import string using client specified string method
  • ora-00221 : error on write to control file
  • ora-26671 : maximum number of STREAMS processes exceeded
  • ora-32317 : cannot run a job from a job
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.