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 : 20-08-2017
ORA-12016

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

  • ora-07233 : slemcw: invalid file handle, seals do not match.
  • ora-07587 : spdcr: $CREPRC failure
  • ora-14276 : EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table
  • ora-01874 : time zone hour must be between -12 and 14
  • ora-01922 : CASCADE must be specified to drop 'string'
  • ora-12737 : Instant Client Light: unsupported server character set string
  • ora-28655 : Alter table add overflow syntax error
  • ora-24772 : Cannot mix tightly-coupled and loosely-coupled branches
  • ora-13799 : threshold not found
  • ora-30076 : invalid extract field for extract source
  • ora-29328 : too many datafiles in this tablespace 'string'
  • ora-07468 : spwat: mset error, unable to set semaphore.
  • ora-32811 : subscriber string already exists
  • ora-29826 : keyword FOR is missing
  • ora-27017 : skgfcls: media handle returned by sbtinfo exceeds max length(SSTMXQMH)
  • ora-02391 : exceeded simultaneous SESSIONS_PER_USER limit
  • ora-19562 : file string is empty
  • ora-01041 : internal error. hostdef extension doesn't exist
  • ora-14163 : subpartition number string: INITRANS value must be less than MAXTRANS value
  • ora-39078 : unable to dequeue message for agent string from queue "string"
  • ora-02257 : maximum number of columns exceeded
  • ora-02853 : Invalid server list latch time out value
  • ora-08450 : invalid specification of CR in picture mask
  • ora-35282 : (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])
  • ora-27121 : unable to determine size of shared memory segment
  • ora-30737 : cannot create subtable of a type which is not a subtype of the type of the supertable
  • ora-32589 : unable to drop minimal supplemental logging
  • ora-26060 : Can not convert type identifier for column string
  • ora-25005 : cannot CREATE INSTEAD OF trigger on a read-only view
  • ora-10568 : Failed to allocate recovery state object: out of SGA memory
  • 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.