ORA-22807: cannot resolve to a scalar type or a collection type

Cause : Ivnaildu s eo fan o-nsaclra f(o reaxmlpe ,ojbetc ytp)e tie.m

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

Cahneg htei tme' sdtaat yep nadr ertyt h eoeprtaino.

update : 28-05-2017
ORA-22807

ORA-22807 - cannot resolve to a scalar type or a collection type
ORA-22807 - cannot resolve to a scalar type or a collection type

  • ora-29550 : Java session state cleared
  • ora-28049 : the password has expired
  • ora-13269 : internal error [string] encountered when processing geometry table
  • ora-30134 : reserved for future use
  • ora-24321 : inconsistent parameters passed
  • ora-09792 : sllfop: cannot allocate read buffer.
  • ora-09839 : removeCallback: callback port is not in the callback set.
  • ora-19005 : Duplicate XMLType LOB storage option
  • ora-12918 : Invalid tablespace type for default permanent tablespace
  • ora-09260 : sigpidu: error obtaining process id
  • ora-09719 : osncui: invalid handle.
  • ora-01754 : a table may contain only one column of type LONG
  • ora-01171 : datafile string going offline due to error advancing checkpoint
  • ora-01944 : IDENTIFIED EXTERNALLY already specified
  • ora-13833 : SQL profile named string doesn't exist
  • ora-19729 : File string is not the initial version of the plugged in datafile
  • ora-13332 : invalid LRS point
  • ora-02345 : cannot create a view with column based on CURSOR operator
  • ora-01230 : cannot make read only - file string is offline
  • ora-38439 : invalid operation "string"
  • ora-16799 : Redo Apply is offline
  • ora-26021 : index string.string partition string loaded successfully with string keys
  • ora-02356 : The database is out of space. The load cannot continue
  • ora-00453 : backgroud process 'string' is dead
  • ora-30937 : No schema definition for 'string' (namespace 'string') in parent 'string'
  • ora-01208 : data file is an old version - not accessing current version
  • ora-23309 : object string.string of type string exists
  • ora-01518 : CREATE DATABASE must specify more than one log file
  • ora-24065 : propagation for QUEUE string and DESTINATION string already disabled
  • ora-01254 : cannot end online backup - file string in recovery manager backup
  • 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.