ORA-02342: replacement type has compilation errors

Cause : The ues of teh ALTE.R..REPALCE sttaemento n a vlaid tyep causde a copmilatino erro.r

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

Use teh ALTE.R..REPALCE sttaementt o repalce th etype iwth a avlid tpye whihc doesn ot casue comiplatio nerror.s

update : 26-09-2017
ORA-02342

ORA-02342 - replacement type has compilation errors
ORA-02342 - replacement type has compilation errors

  • ora-12844 : cluster reconfiguration in progress
  • ora-19687 : SPFILE not found in backup set
  • ora-14634 : Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table
  • ora-27513 : parameter string contains invalid value string
  • ora-02084 : database name is missing a component
  • ora-26080 : file "string" is not part of table string.string partition string
  • ora-25953 : join index cannot be a functional index
  • ora-06954 : Illegal file name
  • ora-10560 : block type 'string'
  • ora-00380 : cannot specify db_stringk_cache_size since stringK is the standard block size
  • ora-38421 : attribute string already exists
  • ora-39020 : invalid mode type string
  • ora-28201 : Not enough privileges to enable application role 'string'
  • ora-09851 : soacon: Archmon unable to lock named pipe.
  • ora-23600 : cannot create PROPAGATION, string already exists
  • ora-19705 : tag value exceeds maximum length of string characters
  • ora-25004 : WHEN clause is not allowed in INSTEAD OF triggers
  • ora-14324 : values being added already exist in DEFAULT partition
  • ora-01270 : %s operation is not allowed if STANDBY_PRESERVES_NAMES is true
  • ora-00207 : control files are not for the same database
  • ora-16199 : Terminal recovery failed to recover to a consistent point
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-27041 : unable to open file
  • ora-19006 : XMLType TYPE storage option not appropriate for storage type
  • ora-38762 : thread string redo log with scn string could not be found
  • ora-07327 : smpdal: attempt to destroy pga when it was not mapped.
  • ora-31083 : error while creating SQL type "string"."string"
  • ora-39033 : Data cannot be filtered under the direct path access method.
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-36883 : (XSSRF02) The first parameter of an AW single row function cannot be NULL.
  • 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.