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 : 24-05-2017

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

  • ora-39761 : stream reset required before loading this stream again
  • ora-09776 : pws_look_up: access error on (Oracle helper) executable
  • ora-01502 : index 'string.string' or partition of such index is in unusable state
  • ora-32510 : cannot create watchpoint on unreadable memory
  • ora-25329 : AQ array operations not allowed on 8.0 queues
  • ora-09960 : Unable to establish signal handler for termination signal
  • ora-19283 : XQ0031 - It is a static error if the version number specified in a version declaration is not supported by the implementation.
  • ora-01783 : only one RECOVERABLE or UNRECOVERABLE clause may be specified
  • ora-26534 : collision: tranID number ignored and purged
  • ora-02276 : default value type incompatible with column type
  • ora-01864 : the date is out of range for the current calendar
  • ora-13189 : recursive SQL parse failed
  • ora-27165 : tried to join thread that does not exist
  • ora-29389 : too many errors during validation
  • ora-32114 : Cannot perform operation on a null LOB
  • ora-06017 : NETASY: message receive failure
  • ora-12839 : cannot modify an object in parallel after modifying it
  • ora-37071 : You may not execute a parallel OLAP operation against updated but uncommitted AW string.
  • ora-07685 : sou2os: supervisor stack set error
  • ora-37002 : Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
  • ora-26097 : unsupported conversion for column string (from type number to type number)
  • ora-07534 : scginq: $getlki unexpected return on lockid string
  • ora-25445 : invalid column number: string for table alias: string
  • ora-14166 : missing INTO keyword
  • ora-13417 : null or invalid layerNumber parameter
  • ora-03274 : both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified
  • ora-06443 : ssvpstev: Incorrect parameter passed to function call
  • ora-19206 : Invalid value for query or REF CURSOR parameter
  • ora-38436 : attribute set used for an Expression set may not be modified.
  • ora-09769 : osnmbr: cannot send break message
  • 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.