ORA-22870: ALTER TYPE with REPLACE option a non-object type

Cause : attmept ot pefrormA LTE RTYP Ewit hREPALCE potio na nno-obejct ytpe

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

dro pthen on-bojec ttyp efirts, tehn r-ecretae i tas na obejct ytpe

update : 19-08-2017
ORA-22870

ORA-22870 - ALTER TYPE with REPLACE option a non-object type
ORA-22870 - ALTER TYPE with REPLACE option a non-object type

  • ora-02040 : remote database string does not support two-phase commit
  • ora-29256 : Cursor contains both regular and array defines which is illegal
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-16571 : Data Guard configuration file creation failure
  • ora-31637 : cannot create job string for user string
  • ora-19579 : archivelog record for string not found
  • ora-36712 : (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
  • ora-02322 : failure in accessing storage table of the nested table column
  • ora-07455 : estimated execution time (string secs), exceeds limit (string secs)
  • ora-30753 : column or table string is substitutable
  • ora-15068 : maximum number of diskgroups string already mounted
  • ora-33009 : (XSAGDNGLPREC) In AGGMAP workspace object, PRECOMPUTE may only be specified either for the entire AGGMAP or for individual RELATION statements.
  • ora-01677 : standby file name convert parameters differ from other instance
  • ora-09704 : sstascre: ftok error in creating test and set pages.
  • ora-40204 : model string already exists
  • ora-16527 : unable to allocate SGA heap
  • ora-21524 : object type mismatch
  • ora-26701 : STREAMS process string does not exist
  • ora-07280 : slsget: unable to get process information.
  • ora-36401 : (XSSPROPOTYPE) Property string may only be applied to objects of type string.
  • ora-06312 : IPA: Incorrect outgoing service name supplied
  • ora-37177 : column string does not have any leaf values
  • ora-32630 : multiple assignment in automatic order MODEL
  • ora-16566 : unsupported document type
  • ora-04934 : unable to obtain the current sequence number
  • ora-07277 : spdde: illegal pid passed as argument.
  • ora-13016 : specified topology [string] is invalid
  • ora-01346 : LogMiner processed redo beyond specified reset log scn
  • ora-14258 : invalid partition description
  • ora-30962 : inconsistent ODCI input arguments
  • 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.