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-07-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-36972 : (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.
  • ora-08465 : input mask contains more than 32 characters
  • ora-02877 : smpini: Unable to initialize memory protection
  • ora-29545 : badly formed class: string
  • ora-02438 : Column check constraint cannot reference other columns
  • ora-21603 : property id [string] is invalid
  • ora-16146 : standby destination control file enqueue unavailable
  • ora-31610 : cannot call this function from a non-master process
  • ora-28530 : Heterogeneous Services initialization error in NLS language ID
  • ora-01274 : cannot add datafile 'string' - file could not be created
  • ora-06116 : NETTCP: unable to create ORASRV process
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-02493 : invalid file increment size in NEXT clause
  • ora-31114 : XDB configuration has been deleted or is corrupted
  • ora-09211 : sfwfb: error writing to file
  • ora-25312 : Cannot specify nonzero sender protocol
  • ora-30510 : system triggers cannot be defined on the schema of SYS user
  • ora-25013 : OLD and PARENT values cannot be identical
  • ora-24275 : function 'string' parameter 'string' missing or invalid
  • ora-31643 : unable to close dump file "string"
  • ora-32550 : Replacement occured despite hint to the contrary
  • ora-12002 : there is no materialized view log on table "string"."string"
  • ora-30552 : The package/procedure/function cannot be changed
  • ora-38478 : creation of system trigger EXPFIL_DROPOBJ_MAINT failed
  • ora-06722 : TLI Driver: connection setup failure
  • ora-00328 : archived log ends at change string, need later change string
  • ora-28047 : database is not a member of any enterprise domain in OID
  • ora-25266 : didnt try to dequeue by message id. with the signature
  • ora-32407 : cannot exclude new values when materialized view log includes new values
  • ora-31208 : DBMS_LDAP: PL/SQL - Invalid LDAP Message.
  • 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.