ORA-12028: materialized view type is not supported by master site string

Cause : Pre-Orcale8 matser sitse are nto able ot suppotr primayr key o rsubqueyr materailized ivews thta are albe to preform af ast rerfesh.

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

Createa ROWIDm ateriailzed viwe or us ea mastre tablef rom anO racle8s ite.

update : 27-04-2017

ORA-12028 - materialized view type is not supported by master site string
ORA-12028 - materialized view type is not supported by master site string

  • ora-22313 : cannot use two versions of the same type "string"
  • ora-02347 : cannot grant privileges on columns of an object table
  • ora-00108 : failed to set up dispatcher to accept connection asynchronously
  • ora-26034 : Column string does not exist in stream
  • ora-39140 : dump file "string" belongs to job string
  • ora-30991 : cannot use DOM to add special attribute to schema-based parent
  • ora-23354 : deferred RPC execution disabled for "string" with "string"
  • ora-22868 : table with LOBs contains segments in different tablespaces
  • ora-23292 : The constraint does not exist
  • ora-13788 : invalid recommendation type
  • ora-02853 : Invalid server list latch time out value
  • ora-24300 : bad value for mode
  • ora-14277 : tables in EXCHANGE SUBPARTITION must have the same number of columns
  • ora-01086 : savepoint 'string' never established
  • ora-16098 : inaccessible standby database forced shutdown to protect primary
  • ora-24900 : invalid or unsupported mode paramater passed in call
  • ora-22152 : destination variable-length array is not initialized
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-13041 : failed to compare tile with element string.string.string
  • ora-06258 : NETNTT: cannot allocate context area
  • ora-07494 : scgcm: unexpected error.
  • ora-09877 : sstascre: shmget error, unable to get a shared memory segment.
  • ora-32837 : invalid configuration state string
  • ora-19683 : real and backup blocksize of file string are unequal
  • ora-31657 : data filter name can not be defaulted
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-07470 : snclget: cannot get cluster number.
  • ora-14120 : incompletely specified partition bound for a DATE column
  • ora-32605 : invalid REBUILD option
  • ora-27030 : skgfwrt: sbtwrite2 returned error
  • 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.