ORA-22910: cannot specify schema name for nested tables

Cause : Tbal enmaew a sqaulfiide iwt hshceam anm ei nteh ensetdt albec oulm'ns( o rattrbiuet')s tsoarg ecalues.

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

R-esepcfiyt h ensetde atbel tie'mss troaeg lcasuew ihtotu htes cehm anmaeq ulaiifctaino.B yd eafutl,t h esotrgaet albef o rteh ensetdt albei tme si rcetae di nteh asm eshceam sa htec otnaniign atbel.

update : 18-08-2017
ORA-22910

ORA-22910 - cannot specify schema name for nested tables
ORA-22910 - cannot specify schema name for nested tables

  • ora-15178 : directory 'string' is not empty; cannot drop this directory
  • ora-02448 : constraint does not exist
  • ora-01951 : ROLE 'string' not granted to 'string'
  • ora-27001 : unsupported device type
  • ora-13787 : missing SQL profile for statement object "string" for tuning task "string"
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-23533 : object "string"."string" can not be cached
  • ora-29326 : SET COMPATIBILITY release number higher than string
  • ora-09844 : soacon: Archmon unable to open named pipe.
  • ora-07612 : $GETUAI failed in retrieving the user's clearance level
  • ora-16517 : the object handle is invalid
  • ora-07431 : fork failed
  • ora-13514 : Metric Capture too close to last capture, group string
  • ora-29382 : validation of pending area failed
  • ora-29818 : column name not properly specified
  • ora-25179 : invalid PCTTHRESHOLD storage option value
  • ora-24328 : illegal attribute value
  • ora-31066 : Insertion of string into string creates a cycle
  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-30088 : datetime/interval precision is out of range
  • ora-15063 : ASM discovered an insufficient number of disks for diskgroup "string"
  • ora-31607 : function string is inconsistent with transform.
  • ora-01575 : timeout waiting for space management resource
  • ora-39312 : call to DBMS_SCHEMA_COPY.CLEAN_TARGET is not legal
  • ora-19590 : conversation already active
  • ora-15005 : name "string" is already used by an existing alias
  • ora-32024 : invalid directory specified for audit_file_dest parameter
  • ora-25461 : rule set not specified
  • ora-12549 : TNS:operating system resource quota exceeded
  • ora-01228 : SET DATABASE option required to install seed database
  • 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.