ORA-02297: cannot disable constraint (string.string) - dependencies exist

Cause : a natle rtbal edsialbec osntaritn afieldb eucaes htet albeh a sfroigenk esy hta taer pdednetn no hti scnosrtanit.

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

Etihre idsbal eteh ofrieg nkye ocntsrianst ro sued iasbel acsacde

update : 27-04-2017
ORA-02297

ORA-02297 - cannot disable constraint (string.string) - dependencies exist
ORA-02297 - cannot disable constraint (string.string) - dependencies exist

  • ora-00272 : error writing archive log string
  • ora-26020 : index string.string loaded successfully with string keys
  • ora-14407 : partitioned table contains subpartitions in a different tablespace
  • ora-19931 : file string has invalid creation SCN string
  • ora-13825 : missing SQL statement text for create SQL profile
  • ora-14045 : only one partition may be modified
  • ora-30505 : system triggers should not reference a column in a WHEN clause
  • ora-27208 : syntax error in device PARMS - environment variable value missing
  • ora-07684 : sou2os: supervisor stack reset error
  • ora-02148 : EXCLUSIVE specified multiple times
  • ora-01774 : Dump undo option specified more than once
  • ora-14131 : enabled UNIQUE constraint exists on one of the tables
  • ora-33064 : (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
  • ora-01598 : rollback segment 'string' is not online
  • ora-29289 : directory access denied
  • ora-09265 : spwat: error temporarily suspending process
  • ora-39129 : Object type string not imported. Name conflicts with the master table
  • ora-38792 : encountered unknown flashback record from release string
  • ora-39146 : schema "string" does not exist
  • ora-29274 : fixed-width multibyte character set not allowed for a URL
  • ora-39950 : invalid parameter for PLSQL warnings flag
  • ora-09218 : sfrfs: failed to refresh file size
  • ora-00209 : control file blocksize mismatch, check alert log for more info
  • ora-12655 : Password check failed
  • ora-26566 : Couldn't open connect to string
  • ora-28353 : failed to open wallet
  • ora-32059 : deadlock detected on mapping structures
  • ora-10361 : check buffer change vector count consistency
  • ora-01861 : literal does not match format string
  • ora-26506 : null global context
  • 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.