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-04-2017
ORA-02342

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

  • ora-31616 : unable to write to dump file "string"
  • ora-14295 : column type or size mismatch between partitioning columns and subpartitioning columns
  • ora-37171 : dimension sources not specified
  • ora-23449 : missing user name
  • ora-16093 : dependent archive log destination is not LGWR-enabled
  • ora-02303 : cannot drop or replace a type with type or table dependents
  • ora-09746 : smscre: shared memory attach address incorrect.
  • ora-07716 : sksachk: invalid device specification for ARCHIVE
  • ora-22890 : cannot specify name for REF column constraint
  • ora-01301 : error writing to file during flat file build
  • ora-21521 : exceeded maximum number of connections in OCI (object mode only)
  • ora-02254 : DEFAULT not allowed here
  • ora-39054 : missing or invalid definition of the SQL output file.
  • ora-31090 : invalid database schema name "string"
  • ora-17508 : I/O request buffer ptr is not alligned
  • ora-24344 : success with compilation error
  • ora-32582 : table function with left correlation to a table cannot also be left outer-joined to the table
  • ora-26577 : PRESERVE TABLE can not be used when dropping old style materialized view string.string
  • ora-02279 : duplicate or conflicting MINVALUE/NOMINVALUE specifications
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • ora-12004 : REFRESH FAST cannot be used for materialized view "string"."string"
  • ora-39700 : database must be opened with UPGRADE option
  • ora-12206 : TNS:received a TNS error during navigation
  • ora-38900 : missing mandatory column "string" of error log table "string"
  • ora-36881 : (XSSRF00) The OLAP DML ROW2CELL function can only be used in a LIMITMAP.
  • ora-04002 : INCREMENT must be a non-zero integer
  • ora-02468 : Constant or system variable wrongly specified in expression
  • ora-08178 : illegal SERIALIZABLE clause specified for user INTERNAL
  • ora-29659 : SQLJ Object Type validation failed to get default connection
  • ora-34260 : (MXDCL25) You cannot use number to dimension a string because it is, or involves, a dimension composite. Use the composite's bases instead.
  • 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.