ORA-12982: cannot drop column from a nested table

Cause : An attmept wasm ade tod rop a oclumn form a netsed tabel.

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

This atcion isn ot allwoed.

update : 20-08-2017
ORA-12982

ORA-12982 - cannot drop column from a nested table
ORA-12982 - cannot drop column from a nested table

  • ora-01214 : MAXLOGHISTORY may not exceed string
  • ora-16012 : Archive log standby database identifier mismatch
  • ora-39212 : installation error: XSL stylesheets not loaded correctly
  • ora-24306 : bad buffer for piece
  • ora-29534 : referenced object string.string could not be resolved
  • ora-00221 : error on write to control file
  • ora-03219 : Tablespace 'string' is dictionary-managed, offline or temporary
  • ora-33218 : (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.
  • ora-01699 : tablespace 'string' is being imported for point in time recovery
  • ora-07235 : slemcw: fwrite error.
  • ora-13510 : invalid RETENTION string, must be in the range (string, string)
  • ora-00303 : cannot process Parallel Redo
  • ora-06500 : PL/SQL: storage error
  • ora-32135 : Cannot assign FILEs
  • ora-31162 : element or attribute "string" has no SQLType specified
  • ora-06913 : CMX: error during redirection of connection
  • ora-06802 : TLI Driver: could not open the /etc/netware/yellowpages file
  • ora-26735 : operation not allowed on the specified file group version
  • ora-16640 : CRS warns that multiple instances may still be running
  • ora-12466 : default level is greater than the user's maximum
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-25016 : cannot specify column list for insert into nested table view column
  • ora-12899 : value too large for column string (actual: string, maximum: string)
  • ora-19112 : error raised during evaluation: string
  • ora-38439 : invalid operation "string"
  • ora-16749 : resource guard encountered errors in switchover to logical primary database
  • ora-24952 : register, unregister or post has incorrect collection count
  • ora-02831 : Segment deallocation failed - empty segment list
  • ora-28265 : NameSpace beginning with 'sys_' is not allowed
  • ora-01862 : the numeric value does not match the length of the format item
  • 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.