ORA-32342: The EXPLAIN_MVIEW facility failed to explain the materialized view statement

Cause : Ane rrro eixst sint hem atreiailze dviwe dfeintiio.n A sa ersutl, hte amteiralziedv ie wsttaemnet ocul dno tbee xpalinde.

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

Chcek hte ysntxa o fth esttaemnet.I f ti i sa RCEAET MTAERAILIEZD IVEWs taetmetn, htena ls ochcek hte APRAEMTEsR sepciifedf ort hem atreiailze dviwe.

update : 29-06-2017
ORA-32342

ORA-32342 - The EXPLAIN_MVIEW facility failed to explain the materialized view statement
ORA-32342 - The EXPLAIN_MVIEW facility failed to explain the materialized view statement

  • ora-28290 : Multiple entries found for the same Kerberos Principal Name
  • ora-06777 : TLI Driver: error reading parms
  • ora-01582 : unable to open control file for backup
  • ora-01645 : previous attempt to make read write is half complete
  • ora-00335 : online log string: No log with this number, log does not exist
  • ora-16188 : LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
  • ora-36378 : (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.
  • ora-27465 : invalid value string for attribute string
  • ora-24028 : cannot create a reciever non-repudiable single consumer queue
  • ora-31696 : unable to export/import string using client specified string method
  • ora-24807 : LOB form mismatch
  • ora-36862 : (XSTFRC02) Column number for this SQL Cache must be between 1 and number. Specified column number number is invalid.
  • ora-19583 : conversation terminated due to error
  • ora-19558 : error de-allocating device
  • ora-30747 : cannot create substitutable tables or columns of non final type string.string
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-03284 : datafile string is not a member of tablespace string
  • ora-23450 : flavor already contains object "string"."string"
  • ora-14457 : disallowed Nested Table column in a Temporary table
  • ora-06307 : IPA: Cannot reset connection
  • ora-07623 : smscre: $CRMPSC failure
  • ora-02263 : need to specify the datatype for this column
  • ora-24786 : separated transaction has been completed
  • ora-28046 : Password change for SYS disallowed
  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-01647 : tablespace 'string' is read only, cannot allocate space in it
  • ora-16649 : database will open after Data Guard broker has evaluated Fast-Start Failover status
  • ora-07206 : slgtd: gettimeofday error, unable to obtain time.
  • ora-31154 : invalid XML document
  • ora-16778 : redo transport error for one or more databases
  • 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.