ORA-22914: DROP of nested tables not supported

Cause : Atetmpetd ot DORP anetsedt abel.

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

netsedt abels acnnto b eexlpictilyd ropped .netsedt abels acn nolyb e rdopepd yb dorppnig htei rcotnaiinngp arnet atbl.e

update : 30-04-2017
ORA-22914

ORA-22914 - DROP of nested tables not supported
ORA-22914 - DROP of nested tables not supported

  • ora-30484 : missing window specification for this function
  • ora-09319 : slgtd: unable to obtain the current date and time
  • ora-36970 : (XSRELTBL12) workspace object must be a self-relation.
  • ora-12154 : TNS:could not resolve the connect identifier specified
  • ora-00097 : use of Oracle SQL feature not in SQL92 string Level
  • ora-22287 : invalid or modified directory occurred during string operation
  • ora-23348 : cannot replicate procedure string; only IN parameters supported
  • ora-19772 : change tracking file name exceeds limit of string characters
  • ora-35578 : (SQLOUT11) SQL cursor 'number' cannot be used with CURRENT OF syntax
  • ora-29272 : initialization failed
  • ora-24386 : statement/server handle is in use when being freed
  • ora-12616 : TNS:no event signals
  • ora-38771 : unnamed datafile(s) added to control file by flashback recovery
  • ora-12538 : TNS:no such protocol adapter
  • ora-02773 : Invalid maximum client wait time
  • ora-28673 : Merge operation not allowed on an index-organized table
  • ora-21702 : object is not instantiated or has been de-instantiated in cache
  • ora-37007 : (AWLISTALL05) number writer
  • ora-16717 : clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed
  • ora-29504 : invalid or missing schema name
  • ora-12036 : updatable materialized view log is not empty, refresh materialized view
  • ora-24777 : use of non-migratable database link not allowed
  • ora-38859 : instance string (thread string) is not ready to be disabled
  • ora-01117 : adding file 'string' with illegal block size: string; limit is string
  • ora-21527 : internal OMS driver error
  • ora-06252 : NETNTT: cannot open address file
  • ora-02828 : Segment free list is empty
  • ora-24275 : function 'string' parameter 'string' missing or invalid
  • ora-04044 : procedure, function, package, or type is not allowed here
  • ora-33288 : (DBERR15) Another user has incompatible access to analytic workspace string, and the wait timeout has expired.
  • 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.