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 : 27-05-2017
ORA-02342

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

  • ora-31691 : The worker received message number string from the MCP, which is invalid.
  • ora-07585 : spdcr: $PARSE failure
  • ora-39168 : Object path string was not found.
  • ora-01107 : database must be mounted for media recovery
  • ora-12410 : internal policy error for policy: string Error: string
  • ora-32576 : missing TYPE keyword
  • ora-17622 : failed to deregister the memory with Oracle Disk Manager library
  • ora-10927 : trace name context forever
  • ora-13365 : layer SRID does not match geometry SRID
  • ora-19322 : An error occurred while reading from host (string): port (string)
  • ora-31512 : name cannot contain double quotation marks
  • ora-04000 : the sum of PCTUSED and PCTFREE cannot exceed 100
  • ora-39079 : unable to enqueue message string
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-12084 : must use ALTER MATERIALIZED VIEW to alter "string"."string"
  • ora-39305 : schema "string" does not exist
  • ora-01684 : max # extents (string) reached in table string.string partition string
  • ora-30396 : rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater
  • ora-16194 : Modifying DB_UNIQUE_NAME requires SID='*' qualifier
  • ora-27502 : IPC error deleting OSD context
  • ora-06102 : NETTCP: cannot allocate context area
  • ora-28551 : pass-through SQL: SQL parse error
  • ora-02821 : Unable to read the requested number of blocks.
  • ora-31194 : Resource string is already deleted
  • ora-06811 : TLI Driver: could not set the IPX network number at init
  • ora-06926 : CMX: T_ERROR during read data
  • ora-19724 : snapshot too old: snapshot time is before file string plug-in time
  • ora-06549 : PL/SQL: failed to dynamically open shared object (DLL): string
  • ora-09214 : sfdone: I/O error detected
  • ora-02434 : cannot enable unique(string) - unique key not defined for table
  • 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.