ORA-25130: cannot modify primary key - primary key not defined for table

Cause : Attempted to modify a primary key that is not defined for the table.

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


update : 24-09-2017

ORA-25130 - cannot modify primary key - primary key not defined for table
ORA-25130 - cannot modify primary key - primary key not defined for table

  • ora-25437 : duplicate table value for table alias: string
  • ora-36882 : (XSSRF01) The second parameter of an AW single row function cannot be NULL.
  • ora-10284 : simulate zero/infinite asynch I/O buffering
  • ora-28662 : IOT index and overflow segments must share the same LOGGING attribute
  • ora-10266 : Trace OSD stack usage
  • ora-34019 : (MSCGADD03) workspace object is not a LIST PARTITION TEMPLATE.
  • ora-26036 : subpartition load specified but table string is not subpartitioned
  • ora-38723 : Invalid SCN expression.
  • ora-24395 : cannot reinitialize non-existent pool
  • ora-27141 : invalid process ID
  • ora-01481 : invalid number format model
  • ora-35074 : (QFHEAD02) EIF file string cannot be read by this version of string.
  • ora-08313 : sllfop: could not allocate buffers
  • ora-31447 : cannot create change tables in the SYS schema
  • ora-15178 : directory 'string' is not empty; cannot drop this directory
  • ora-29706 : incorrect value string for parameter ACTIVE_INSTANCE_COUNT
  • ora-19698 : %s is from different database: id=string, db_name=string
  • ora-01259 : unable to delete datafile string
  • ora-24201 : duplicate publisher, publisher already added to the queue
  • ora-01267 : Failure getting date/time
  • ora-29970 : Specified registration id does not exist
  • ora-27036 : translation error, unable to expand file name
  • ora-14045 : only one partition may be modified
  • ora-08468 : mask option string is not supported
  • ora-19114 : error during parsing the XQuery expression: string
  • ora-15064 : communication failure with ASM instance
  • ora-12415 : A column of another datatype exists on the specified table
  • ora-39309 : schema sync operation failed
  • ora-03218 : invalid option for CREATE/ALTER TABLESPACE
  • ora-22630 : attribute [string] is null or it is not well-formed
  • 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.