ORA-12089: cannot online redefine table "string"."string" with no primary key

Cause : An attempt was made to online redefine a table that does not have a primary key defined on it.

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

Do not attempt to online redefine a table that does not have a primary key defined on it.

update : 24-09-2017

ORA-12089 - cannot online redefine table "string"."string" with no primary key
ORA-12089 - cannot online redefine table "string"."string" with no primary key

  • ora-10918 : TABLESPACE GROUP name cannot be the same as tablespace name
  • ora-12007 : materialized view reuse parameters are inconsistent
  • ora-06563 : top level procedure/function specified, cannot have subparts
  • ora-32340 : cannot tune the materialized view definition
  • ora-29957 : cannot create a function-based domain index on a string table
  • ora-06134 : NETTCP: file access privilege violation
  • ora-10943 : trace name context forever
  • ora-16775 : target standby database in broker operation has potential data loss
  • ora-08007 : Further changes to this block by this transaction not allowed
  • ora-07460 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-28156 : Proxy user 'string' not authorized to set role 'string' for client 'string'
  • ora-22901 : cannot compare nested table or VARRAY or LOB attributes of an object type
  • ora-38430 : Operation "string" not supported in the current release.
  • ora-19671 : media management software returned invalid proxy handle
  • ora-39049 : invalid parameter name string
  • ora-26512 : error pushing transaction to def$error
  • ora-16544 : modifying DG_BROKER_START requires SID='*' qualifier
  • ora-31475 : redo log catalog contains no metadata for the source table
  • ora-07740 : slemop: incorrect handle size (programming error)
  • ora-26730 : %s 'string' already exists
  • ora-09350 : Windows 32-bit Two-Task driver unable to allocate context area
  • ora-22801 : invalid object row variable
  • ora-37072 : (XSMCSESS00) Object workspace object has the wrong type.
  • ora-28279 : Error reading ldap_directory_access init parameter.
  • ora-01483 : invalid length for DATE or NUMBER bind variable
  • ora-24325 : this OCI operation is not currently allowed
  • ora-19663 : cannot apply current offline range to datafile string
  • ora-01278 : error creating file 'string'
  • ora-02251 : subquery not allowed here
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • 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.