ORA-02296: cannot enable (string.string) - null values found

Cause : an alter table enable constraint failed because the table contains values that do not satisfy the constraint.

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


update : 26-06-2017

ORA-02296 - cannot enable (string.string) - null values found
ORA-02296 - cannot enable (string.string) - null values found

  • ora-38501 : sub-query not allowed in the expression
  • ora-24308 : illegal define position
  • ora-33313 : (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
  • ora-02357 : no valid dump files
  • ora-27159 : failure setting process scheduling priority
  • ora-12425 : cannot apply policies or set authorizations for system schemas
  • ora-36184 : (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
  • ora-13304 : failure to insert a transformed geometry object in a table
  • ora-30348 : ADD and DROP cannot both be specified
  • ora-06801 : TLI Driver: listen for SPX server reconnect failed
  • ora-16658 : unobserved Fast-Start Failover configuration
  • ora-12703 : this character set conversion is not supported
  • ora-40001 : value for string must be greater than zero
  • ora-02486 : Error in writing trace file string
  • ora-01252 : cannot prevent writes - file string in recovery manager backup
  • ora-09772 : osnpmetbrkmsg: message from host had incorrect message type
  • ora-34243 : (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
  • ora-26524 : nls subsystem initialization failure for product=string, facility=string
  • ora-26089 : LONG column "string" must be specified last
  • ora-35917 : (XSHIDE05) You cannot HIDE model workspace object because the analytic workspace in which it is defined has not been upgraded to version string.
  • ora-16531 : unable to post message
  • ora-24026 : operation failed, queue string.string has errors
  • ora-19267 : XQ0047 - module string not found
  • ora-36648 : (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.
  • ora-24008 : queue table string.string must be dropped first
  • ora-02801 : Operations timed out
  • ora-30066 : test support - drop rollback segment wait
  • ora-21707 : pin duration is longer than allocation duration
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-24385 : Application context size or index is not valid
  • 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.