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 : 26-04-2017
ORA-12981

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

  • ora-29555 : Java source, class or resource is not allowed here
  • ora-32107 : internal OCI memory allocation failure
  • ora-31005 : Path name length string exceeds maximum length string
  • ora-31651 : communication error with master process - detaching job
  • ora-12661 : Protocol authentication to be used
  • ora-27491 : repeat_interval and start_date cannot both be NULL
  • ora-38407 : The ADT associated with the attribute set already exists.
  • ora-25193 : cannot use COMPRESS option for a single column key
  • ora-06321 : IPA: Cannot reach the remote side
  • ora-00703 : maximum number of row cache instance locks exceeded
  • ora-29272 : initialization failed
  • ora-08449 : invalid numeric symbol found in picture mask
  • ora-01635 : rollback segment #string specified not available
  • ora-01873 : the leading precision of the interval is too small
  • ora-12441 : policy string already exists
  • ora-25183 : index-organized table top index segment is in a different tablespace
  • ora-15126 : component within ASM file name 'string' exceeds maximum length
  • ora-12036 : updatable materialized view log is not empty, refresh materialized view
  • ora-13524 : error encountered while retrieving baseline information
  • ora-30356 : the specified refresh method is not supported in this context
  • ora-28359 : invalid certificate identifier
  • ora-10640 : Operation not permitted during SYSTEM tablespace migration
  • ora-19665 : size string in file header does not match actual file size of string
  • ora-39157 : error appending extension to file "string"
  • ora-13827 : null or zero length attribute specified in SQL profile collection
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-17501 : logical block size string is invalid
  • ora-29501 : invalid or missing Java source, class, or resource name
  • ora-23408 : this replication operation is not supported in a mixed configuration
  • ora-33460 : (ESDREAD10) Discarding compiled code for workspace object because object workspace object is not in analytic workspace string.
  • 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.