ORA-31083: error while creating SQL type "string"."string"

Cause : An error occurred while trying to create the SQL type based on the specification of a complex type.

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

Fix the identified error and try again.

update : 16-08-2017
ORA-31083

ORA-31083 - error while creating SQL type "string"."string"
ORA-31083 - error while creating SQL type "string"."string"

  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-29519 : name string resolved via a synonym in schema string to a class with a different name
  • ora-06260 : NETNTT: cannot write to remote process
  • ora-13281 : failure in execution of SQL statement to retrieve WKT
  • ora-15157 : rolling upgrade or downgrade is not allowed
  • ora-01333 : failed to establish Logminer Dictionary
  • ora-19238 : XP0018 - focus not defined
  • ora-00260 : cannot find online log sequence string for thread string
  • ora-01185 : logfile group number string is invalid
  • ora-12805 : parallel query server died unexpectedly
  • ora-19639 : file string is more current than this incremental backup
  • ora-01340 : NLS error
  • ora-38306 : this object is not recoverable standalone
  • ora-31019 : Recursive deletion snapshot too old for string/string
  • ora-30357 : this PL/SQL function cannot be supported for query rewrite
  • ora-15101 : no action specified
  • ora-26576 : cannot acquire SR enqueue
  • ora-24775 : cannot prepare or commit transaction with non-zero lock value
  • ora-13460 : GeoRaster metadata SRS error
  • ora-27007 : failed to open file
  • ora-30734 : cannot specify scope constraint on ref column with rowid
  • ora-06523 : Maximum number of arguments exceeded
  • ora-36921 : (XSVPMVTOPART02) workspace object and workspace object are not in the same analytic workspace.
  • ora-29369 : invalid method name string specified for consumer group string
  • ora-01938 : IDENTIFIED BY must be specified for CREATE USER
  • ora-01048 : Couldn't find the specified procedure in the given context
  • ora-30677 : session is already connected to a debugger
  • ora-16710 : the resource guard is out of memory
  • ora-01300 : writable database required for specified LogMiner options
  • ora-09716 : kslcll: Unable to fix in-flux lamport latch.
  • 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.