ORA-02433: cannot disable primary key - primary key not defined for table

Cause : Attempetd to dsiable ap rimaryk ey thti s not edfined ofr the atble.

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


update : 26-09-2017

ORA-02433 - cannot disable primary key - primary key not defined for table
ORA-02433 - cannot disable primary key - primary key not defined for table

  • ora-29286 : internal error
  • ora-15105 : missing or invalid FAILGROUP name
  • ora-09813 : Unable to get directory status
  • ora-25311 : %s not supported for non-persistent queue
  • ora-09341 : scumnt: unable to mount database
  • ora-25293 : Lob attributes must be null for buffered operations
  • ora-12491 : DBHIGH value does not dominate DBLOW
  • ora-16749 : resource guard encountered errors in switchover to logical primary database
  • ora-19028 : Invalid ADT parameter passed to toObject() function
  • ora-12839 : cannot modify an object in parallel after modifying it
  • ora-02275 : such a referential constraint already exists in the table
  • ora-00079 : variable string not found
  • ora-01371 : Complete LogMiner dictionary not found
  • ora-14306 : List value 'string' specified twice in partitions 'string', 'string'
  • ora-32742 : Hang analysis initialize failed
  • ora-39316 : call to DBMS_SCHEMA_COPY.CLEAN_UP is not legal
  • ora-30731 : scope constraint not allowed on nested table column when the nested table is being created
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-22307 : operation must be on a user-defined type
  • ora-12062 : transaction string received out of sequence from site string
  • ora-10373 : parallel query server kill event
  • ora-27213 : failed to unload Media Management Library
  • ora-08105 : Oracle event to turn off smon cleanup for online index build
  • ora-19604 : conversation file naming phase is over
  • ora-07266 : sppst: invalid process number passed to sppst.
  • ora-06137 : NETTCP: error during connection handshake
  • ora-00323 : Current log of thread string not useable and all others need archiving
  • ora-30383 : specified dimension level does not exist in the attribute
  • ora-04070 : invalid trigger name
  • ora-02443 : Cannot drop constraint - nonexistent constraint
  • 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.