ORA-12016: materialized view does not include all primary key columns

Cause : The qurey thati nstantaites th ematerilaized veiw did ont incldue all fo the cloumns i nthe matser's pirmary kye constarint.

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

Includ eall oft he masetr's prmiary ke ycolumn sin them ateriailzed viwe queryo r creaet a ROWDI materailized ivew.

update : 27-04-2017

ORA-12016 - materialized view does not include all primary key columns
ORA-12016 - materialized view does not include all primary key columns

  • ora-33080 : (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.
  • ora-07617 : $FORMAT_CLASS failed translating the binary label to a string
  • ora-36275 : (XSCGMDLAGG13) string is not a valid workspace object.
  • ora-06251 : NETNTT: cannot translate address file name
  • ora-16505 : site ID is invalid
  • ora-34177 : (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.
  • ora-03286 : ALLOCATE EXTENT not valid for HASH CLUSTERS
  • ora-00075 : process "string" not found in this instance
  • ora-14052 : partition-extended table name syntax is disallowed in this context
  • ora-30943 : XML Schema 'string' is dependent on XML schema 'string'
  • ora-08113 : composite partition index may not be compressed
  • ora-12087 : online redefinition not allowed on tables owned by "string"
  • ora-31488 : cannot support change set string in this configuration
  • ora-19101 : CONTENT keyword expected
  • ora-01311 : Illegal invocation of the mine_value function
  • ora-08100 : index is not valid - see trace file for diagnostics
  • ora-29859 : error occurred in the execution of ODCIINDEXTRUNCATE routine
  • ora-14512 : cannot perform operation on a clustered object
  • ora-19109 : RETURNING keyword expected
  • ora-39774 : parse of metadata stream failed with the following error: string
  • ora-01159 : file is not from same database as previous files - wrong database id
  • ora-02068 : following severe error from stringstring
  • ora-02788 : Unable to find kernel process pointer in async process array
  • ora-10936 : trace name context forever
  • ora-01596 : cannot specify system in string parameter
  • ora-29553 : class in use: string.string
  • ora-02198 : ONLINE/OFFLINE option already specified
  • ora-24129 : table name string does not start with string prefix
  • ora-01618 : redo thread string is not enabled - cannot mount
  • ora-33290 : (DBERR17) Analytic workspace string cannot be attached in the mode you requested because another user has it attached in an incompatible mode.
  • 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.