ORA-22627: tc [string] must be that of object/varray/nested table

Cause : yTepc do esin tot ah tfoo jbce/tavrryan/seet datlbe

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

aMeks ru eht eytepc do esiO ICT_PYCEDO_EBOEJTCo rCO_IYTEPOCEDV_RAAR YroO ICT_PYCEDO_EATLBE

update : 29-06-2017
ORA-22627

ORA-22627 - tc [string] must be that of object/varray/nested table
ORA-22627 - tc [string] must be that of object/varray/nested table

  • ora-02186 : tablespace resource privilege may not appear with other privileges
  • ora-26085 : direct path operation must start its own transaction
  • ora-13158 : Oracle object string does not exist
  • ora-01632 : max # extents (string) reached in index string.string
  • ora-10643 : Database should be mounted in restricted mode and Exclusive mode
  • ora-22850 : duplicate LOB storage option specificed
  • ora-13913 : The threshold cannot be set when SYSAUX is offline.
  • ora-16953 : Type of SQL statement not supported.
  • ora-09957 : Unable to send termination request to IMON
  • ora-25506 : resource manager has not been continuously on in some instances
  • ora-06312 : IPA: Incorrect outgoing service name supplied
  • ora-14262 : new subpartition name must differ from the old subpartition name
  • ora-09951 : Unable to create file
  • ora-13840 : Concurrent DDL Error in create SQL profile operation.
  • ora-38951 : Target platform string not cross platform compliant
  • ora-36650 : (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
  • ora-07636 : smsdbp: $MGBLSC failure
  • ora-01179 : file string does not exist
  • ora-02404 : specified plan table not found
  • ora-04043 : object string does not exist
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-24775 : cannot prepare or commit transaction with non-zero lock value
  • ora-28520 : error initializing heterogeneous data dictionary translations
  • ora-39111 : Dependent object type string skipped, base object type string already exists
  • ora-09961 : Unable to restore termination signal handler
  • ora-27399 : job type EXECUTABLE requires the CREATE EXTERNAL JOB privilege
  • ora-01083 : value of parameter "string" is inconsistent with that of other instances
  • ora-40207 : duplicate or multiple function settings
  • ora-28170 : unsupported certificate version
  • ora-16166 : LGWR network server failed to send remote 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.