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-09-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-07251 : spcre: semget error, could not allocate any semaphores.
  • ora-27215 : skgfgsmcs: sbtinfo2 returned unknown file
  • ora-33920 : (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.
  • ora-02148 : EXCLUSIVE specified multiple times
  • ora-02174 : Missing required thread number
  • ora-37004 : (AWLISTALL02) number reader
  • ora-31610 : cannot call this function from a non-master process
  • ora-32590 : log group specification not allowed here
  • ora-16000 : database open for read-only access
  • ora-29526 : created Java class string"string"
  • ora-08005 : specified row does not exist
  • ora-01560 : LIKE pattern contains partial or illegal character
  • ora-01308 : initialization parameter utl_file_dir is not set
  • ora-25465 : variable name not specified
  • ora-22370 : incorrect usage of method string
  • ora-04017 : invalid value string (length = string) for parameter max_dump_file_size
  • ora-01143 : cannot disable media recovery - file string needs media recovery
  • ora-01873 : the leading precision of the interval is too small
  • ora-25136 : this cluster can contain only one table
  • ora-38426 : attribute set assigned to an expression set may not be dropped
  • ora-07757 : slemcc: invalid handle
  • ora-00358 : Too many file members specified, the maximum is string
  • ora-16156 : LGWR archive log dependency not allowed if database is standby protected
  • ora-19904 : test recovery not allowed for datafile string
  • ora-06749 : TLI Driver: option not allowed across network
  • ora-01299 : dictionary string corresponds to a different database incarnation
  • ora-24750 : incorrect size of attribute
  • ora-36735 : A value exceeded the MAX specification
  • ora-29816 : object being disassociated is not present
  • ora-19672 : media management software returned invalid file status
  • 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.