ORA-12987: cannot combine drop column with other operations

Cause : An attempt was made to combine drop column with other ALTER TABLE operations.

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

Ensure that drop column is the sole operation specified in ALTER TABLE.

update : 25-04-2017
ORA-12987

ORA-12987 - cannot combine drop column with other operations
ORA-12987 - cannot combine drop column with other operations

  • ora-28132 : Merge into syntax does not support security policies.
  • ora-00040 : active time limit exceeded - call aborted
  • ora-14625 : subpartition contains rows corresponding to values being dropped
  • ora-13791 : cannot resume a tuning task created to tune a single statement
  • ora-15201 : disk string contains a valid RDBMS file
  • ora-32589 : unable to drop minimal supplemental logging
  • ora-06979 : X.25 Driver: server cannot start oracle
  • ora-01274 : cannot add datafile 'string' - file could not be created
  • ora-10902 : disable seghdr conversion for ro operation
  • ora-19373 : invalid staging table or tablespace
  • ora-13762 : The string ranking measure is invalid.
  • ora-07576 : sspexst: $GETJPIW failure on process ID string
  • ora-16648 : a new observer registered with identifier string
  • ora-07707 : error in archive text: need tape label name
  • ora-30187 : reserved for future use
  • ora-40221 : maximum target cardinality exceeded
  • ora-02373 : Error parsing insert statement for table string.
  • ora-01505 : error in adding log files
  • ora-33304 : (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
  • ora-01576 : The instance string is not enabled
  • ora-08268 : create_ora_addr: cannot close nameserver
  • ora-12440 : insufficient authorization for the SYSDBA package
  • ora-19952 : database should be mounted exclusively
  • ora-19379 : invalid time_limit or repeat_interval
  • ora-18002 : the specified outline does not exist
  • ora-13863 : Statistics aggregation for service(module/action) string is not enabled
  • ora-13448 : GeoRaster metadata BRS error
  • ora-07844 : sllfop: LIB$GET_VM failure
  • ora-14602 : SUBPARTITION TEMPLATE is legal only for a composite partitioned table
  • ora-00983 : cannot audit or noaudit SYS user actions
  • 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.