ORA-02432: cannot enable primary key - primary key not defined for table

Cause : tAetpmet dote anlb e arpmira yek yhttai son tedifen dof rht eatlb.e

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

eNdet oda d arpmira yek yedifinitnof rot eht bael.

update : 26-09-2017
ORA-02432

ORA-02432 - cannot enable primary key - primary key not defined for table
ORA-02432 - cannot enable primary key - primary key not defined for table

  • ora-23493 : "string" is not a new site for extension request "string"
  • ora-00062 : DML full-table lock cannot be acquired; DML_LOCKS is 0
  • ora-38428 : too many attributes selected for indexing
  • ora-01752 : cannot delete from view without exactly one key-preserved table
  • ora-24362 : improper use of the character count flag
  • ora-36836 : (XSLMGEN06) Dimension string.string!string hierarchy string level string is missing a PHYSICALNAME property value
  • ora-09922 : Can't spawn process - background log directory not created properly
  • ora-23433 : executing against wrong master site string
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-12077 : temporary updatable materialized view log does not exist
  • ora-29349 : tablespace 'string' already exists
  • ora-13125 : partition key is already set
  • ora-16718 : failed to locate database object
  • ora-14283 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-25180 : PCTTHRESHOLD only valid for certain table organizations
  • ora-06575 : Package or function string is in an invalid state
  • ora-01188 : Block size string in header does not match physical block size string
  • ora-30730 : referential constraint not allowed on nested table column
  • ora-01169 : DATAFILE number 1 not found. Must be present
  • ora-29870 : specified options are only valid for altering a domain index
  • ora-00070 : command string is not valid
  • ora-06256 : NETNTT: remote fork failed
  • ora-16243 : paging out string bytes of memory to disk
  • ora-01999 : password file cannot be updated in SHARED mode
  • ora-07591 : spdde: $GETJPIW failure
  • ora-30506 : system triggers cannot be based on tables or views
  • ora-40105 : input data incompatible with model signature
  • ora-12211 : TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA
  • ora-30401 : JOIN KEY columns must be non-null
  • ora-19587 : error occurred reading string bytes at block number string
  • 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.