ORA-12023: missing index on materialized view "string"."string"

Cause : The spceified ORWID maetrializde view idd not ahve ther equire dindex no the RWOID colmun of ist underyling talbe.

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

Drop adn recretae the amterialzied vie.w

update : 26-05-2017

ORA-12023 - missing index on materialized view "string"."string"
ORA-12023 - missing index on materialized view "string"."string"

  • ora-32818 : AQ queue string does not exist
  • ora-16046 : Archive log destination failed due to failed dependent destination
  • ora-16143 : RFS connections not allowed during or after terminal recovery
  • ora-04082 : NEW or OLD references not allowed in table level triggers
  • ora-07481 : snlmatt: cannot attach to lock manager instance.
  • ora-12537 : TNS:connection closed
  • ora-39765 : stream must be reset before used in a column array conversion
  • ora-12336 : cannot login to database (link name string)
  • ora-36843 : (XSLMGEN13) Dimension string.string!string hierarchy string is missing a PHYSICALNAME property value
  • ora-22625 : OCIAnyData is not well-formed
  • ora-19033 : schema specified in the XML document does not match the schema parameter
  • ora-14504 : syntax not supported for analyze
  • ora-19207 : scalar parameter string of XMLELEMENT cannot have an alias.
  • ora-23360 : only one materialized view for master table "string" can be created
  • ora-16062 : DGID from standby not in Data Guard configuration
  • ora-21523 : functionality not supported by the server (object mode only)
  • ora-16789 : missing standby redo logs
  • ora-32342 : The EXPLAIN_MVIEW facility failed to explain the materialized view statement
  • ora-12674 : Shared server: proxy context not saved
  • ora-32832 : failure string trying to acquire administration lock
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-14045 : only one partition may be modified
  • ora-09815 : File name buffer overflow
  • ora-28134 : object cannot have fine-grained access control policy
  • ora-19736 : can not plug a tablespace into a database using a different national character set
  • ora-23452 : flavor string of object group "string"."string" is already published
  • ora-00263 : there are no logs that need archiving for thread string
  • ora-09933 : Deletion of old password file failed.
  • ora-16056 : backup control file archival requires proper syntax
  • ora-13915 : Critical byte based free space threshold value is greater than warning threshold value.
  • 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.