ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

Cause : Ana ttmeptt o eprfrom LATE RTYEP wtih ERPLCAE potino fro ap ur einocmpeltet ype

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

Copmleetlyd efnie hte roignialt yp,e bfeor eusnig hte LATE RTYEP wtih ERPLCAE potino.

update : 27-06-2017
ORA-22871

ORA-22871 - ALTER TYPE with REPLACE is not allowed for pure incomplete types
ORA-22871 - ALTER TYPE with REPLACE is not allowed for pure incomplete types

  • ora-00082 : memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring
  • ora-30348 : ADD and DROP cannot both be specified
  • ora-13231 : failed to create index table [string] during R-tree creation
  • ora-02177 : Missing required group number
  • ora-15052 : ASM file name 'string' is not in diskgroup "string"
  • ora-16568 : cannot set property string
  • ora-36612 : (XSLMS01) invalid OLAP message number: value
  • ora-32638 : Non unique addressing in MODEL dimensions
  • ora-30160 : Unable to access the file
  • ora-26101 : tablespace # in file header is string rather than string for file string
  • ora-17501 : logical block size string is invalid
  • ora-13903 : Invalid combination of string threshold value and operator.
  • ora-33998 : (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.
  • ora-29917 : cannot lock a table which gets its rows from a collection operand
  • ora-04022 : nowait requested, but had to wait to lock dictionary object
  • ora-29531 : no method string in class string
  • ora-39042 : invalid transform name string
  • ora-12488 : maximum label does not dominate minimum label
  • ora-01605 : missing numbers in clause "string" of string
  • ora-26035 : Error attempting to encrypt or decrypt column
  • ora-28041 : Authentication protocol internal error
  • ora-39005 : inconsistent arguments
  • ora-16771 : failover to a physical standby database failed
  • ora-14501 : object is not partitioned
  • ora-27374 : insufficient privileges on event source queue
  • ora-31417 : column list contains control column string
  • ora-16502 : the Data Guard broker operation succeeded with warnings
  • ora-31526 : could not find source table string.string for CDC change table string.string
  • ora-28667 : USING INDEX option not allowed for the primary key of an IOT
  • ora-00054 : resource busy and acquire with NOWAIT specified
  • 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.