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

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

  • ora-21600 : path expression too long
  • ora-01562 : failed to extend rollback segment number string
  • ora-26077 : direct path column array is not initialized
  • ora-24850 : failed to startup shared subsystem
  • ora-22958 : This operation is not allowed in check constraints or triggers
  • ora-26672 : timeout occurred while stopping STREAMS process string
  • ora-30487 : ORDER BY not allowed here
  • ora-00100 : no data found
  • ora-02291 : integrity constraint (string.string) violated - parent key not found
  • ora-16557 : the database is already in use
  • ora-06120 : NETTCP: network driver not loaded
  • ora-25280 : complete sender information not provided to non-repudiate sender
  • ora-35018 : (QFCHECK01) The analytic workspace and EIF file definitions of workspace object have a mismatched data type.
  • ora-22973 : size of object identifier exceeds maximum size allowed
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-30036 : unable to extend segment by string in undo tablespace 'string'
  • ora-36706 : (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.
  • ora-12326 : database string is closing immediately; no operations are permitted
  • ora-01353 : existing Logminer session
  • ora-22884 : object modification failed
  • ora-23341 : user function required
  • ora-29539 : Java system classes already installed
  • ora-28051 : the account is locked
  • ora-12920 : database is already in force logging mode
  • ora-16732 : error executing dbms_logstdby.skip procedure
  • ora-25402 : transaction must roll back
  • ora-12229 : TNS:Interchange has no more free connections
  • ora-13376 : invalid type name specified for layer_gtype parameter
  • ora-26058 : unexpected error fetching metadata for column string in table string
  • ora-00600 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [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.