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 : 24-04-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-24808 : streaming of lob data is not allowed when using lob buffering
  • ora-14121 : MODIFY DEFAULT ATTRIBUTES may not be combined with other operations
  • ora-24121 : both cascade and a block range passed to DBMS_REPAIR.CHECK_OBJECT procedure
  • ora-12900 : must specify a default temporary tablespace for a locally managed database
  • ora-16196 : database has been previously opened and closed
  • ora-00090 : failed to allocate memory for cluster database ORADEBUG command
  • ora-01192 : must have at least one enabled thread
  • ora-19239 : XP0019 - step expression must return sequence of nodes
  • ora-09264 : sptpa: error flagging process
  • ora-24333 : zero iteration count
  • ora-16211 : unsupported record found in the archived redo log
  • ora-13266 : error inserting data into table string
  • ora-13108 : spatial table string not found
  • ora-19600 : input file is string string (string)
  • ora-02354 : error in exporting/importing data string
  • ora-40214 : duplicate setting: string
  • ora-32129 : cannot get information about this column
  • ora-31628 : error getting worker process exception
  • ora-21706 : duration does not exist or is invalid
  • ora-12072 : updatable materialized view log data for "string"."string" cannot be created
  • ora-31409 : one or more values for input parameters are incorrect
  • ora-16582 : could not edit instance specific property
  • ora-38029 : object statistics are locked
  • ora-03202 : the scan limit specification is invalid
  • ora-27019 : tape filename length exceeds limit (SBTOPMXF)
  • ora-12672 : Database logon failure
  • ora-22993 : specified input amount is greater than actual source amount
  • ora-32136 : Cannot perform operation on an invalid stream
  • ora-19595 : archivelog string already included in backup conversation
  • ora-31631 : privileges are required
  • 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.