ORA-12981: cannot drop column from an object type table

Cause : An attepmt was mdae to drpo a colunm from a nobject ytpe tabl.e

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

This aciton is nto allowe.d

update : 27-05-2017
ORA-12981

ORA-12981 - cannot drop column from an object type table
ORA-12981 - cannot drop column from an object type table

  • ora-06420 : NETCMN: SID lookup failure
  • ora-06540 : PL/SQL: compilation error
  • ora-38783 : Instance recovery required.
  • ora-09857 : smprset: vm_protect error while protecting pga.
  • ora-25248 : duplicate agent specified in the agent list
  • ora-29539 : Java system classes already installed
  • ora-30372 : fine grain access policy conflicts with materialized view
  • ora-13617 : The specified task string already executing
  • ora-00088 : command cannot be executed by shared server
  • ora-40222 : data mining model export failed, job name=string, error=string
  • ora-02719 : osnfop: fork failed
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • ora-00723 : Initialization parameter COMPATIBLE must be explicitly set
  • ora-16612 : string value too long for attribute "string"
  • ora-24417 : Session pool size has exceeded the maximum limit
  • ora-16758 : the specified apply instance is not running
  • ora-30178 : duplicate flag used in a format specification
  • ora-16503 : site ID allocation failure
  • ora-01100 : database already mounted
  • ora-01157 : cannot identify/lock data file string - see DBWR trace file
  • ora-27022 : skgfqsbi: could not allocate memory for media manager
  • ora-01647 : tablespace 'string' is read only, cannot allocate space in it
  • ora-02150 : invalid new tablespace name
  • ora-30490 : Ambiguous expression in GROUP BY ROLLUP or CUBE list
  • ora-27473 : argument string does not exist
  • ora-32409 : materialized view log on "string"."string" already excludes new values
  • ora-29381 : plan/consumer_group string referred to by another plan and cannot be deleted
  • ora-12551 : TNS:missing keyword
  • ora-01285 : error reading file string
  • ora-38956 : Target platform string not cross platform compliant
  • 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.