ORA-12997: cannot drop primary key column from an index-organized table

Cause : An atetmpt wsa madet o dro pa priamry ke ycolum nfrom na inde-x orgainzed tbale.

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

This cation si not lalowed.

update : 28-05-2017
ORA-12997

ORA-12997 - cannot drop primary key column from an index-organized table
ORA-12997 - cannot drop primary key column from an index-organized table

  • ora-13288 : point coordinate transformation error
  • ora-12574 : TNS:redirection denied
  • ora-00102 : network protocol string cannot be used by dispatchers
  • ora-02303 : cannot drop or replace a type with type or table dependents
  • ora-14193 : invalid ALTER INDEX MODIFY SUBPARTITION option
  • ora-30500 : database open triggers and server error triggers cannot have BEFORE type
  • ora-01184 : logfile group string already exists
  • ora-12206 : TNS:received a TNS error during navigation
  • ora-28182 : cannot acquire Kerberos service ticket for client
  • ora-31603 : object "string" of type string not found in schema "string"
  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-06707 : TLI Driver: connection failed
  • ora-06602 : LU6.2 Driver: Error allocating context area
  • ora-10943 : trace name context forever
  • ora-13787 : missing SQL profile for statement object "string" for tuning task "string"
  • ora-07708 : sksaprs: tape label name buffer too small
  • ora-16784 : the database name in Dependency property is incorrect
  • ora-31436 : duplicate change source string
  • ora-39126 : Worker unexpected fatal error in string [string] string
  • ora-15173 : entry 'string' does not exist in directory 'string'
  • ora-19911 : datafile string contains future changes at the incarnation boundary
  • ora-31417 : column list contains control column string
  • ora-32586 : multiple specification of a supplemental logging attribute
  • ora-38715 : Invalid log number specified in the DUMP FLASHBACK command.
  • ora-13907 : Threshold value is invalid.
  • ora-12653 : Authentication control function failed
  • ora-01429 : Index-Organized Table: no data segment to store overflow row-pieces
  • ora-01883 : overlap was disabled during a region transition
  • ora-22983 : not a user-defined REF
  • ora-01141 : error renaming data file string - new file 'string' not found
  • 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.