ORA-23328: mview base table "string"."string" differs from master table "string"."string"

Cause : Wehnc raetniga amtreilaiezdv iwe htruog hrpecta,t h emtaeirailzde ive wbsaet alben aem iddn o tmtac har elpiactde atbel anm ea tteh amsetr.

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

Cahneg htem aetrailzie dveiwd d lt oues htes aem abs etbal ea steh erpilctae dtbal enmaea tt h emsatre.

update : 25-04-2017
ORA-23328

ORA-23328 - mview base table "string"."string" differs from master table "string"."string"
ORA-23328 - mview base table "string"."string" differs from master table "string"."string"

  • ora-26092 : only LONG or LOB types can be partial
  • ora-23480 : Column string is not a top-level column of "string"."string".
  • ora-07747 : slemrd: $READ failure
  • ora-19916 : %s
  • ora-31163 : element or attribute "string" has invalid attribute value "string" (should be "string")
  • ora-12987 : cannot combine drop column with other operations
  • ora-13632 : The user cancelled the current operation.
  • ora-30060 : Internal event for RECO tracing
  • ora-31502 : invalid number supplied for supplemental_processes
  • ora-31015 : Attempted to insert entry without name
  • ora-07591 : spdde: $GETJPIW failure
  • ora-09271 : szlon: error verifying user name
  • ora-13641 : Task cannot be interrupted yet. You may cancel it instead.
  • ora-13337 : failure in concatenating LRS polygons
  • ora-06431 : ssaio: Invalid Block number
  • ora-29513 : referenced class name too long
  • ora-26563 : renaming this table is not allowed
  • ora-16238 : attempt to use version 9 log
  • ora-06596 : unsupported LOB operation in RPC call
  • ora-08430 : raw data missing leading sign
  • ora-22152 : destination variable-length array is not initialized
  • ora-32774 : more than one file was specified for bigfile tablespace string
  • ora-31492 : could not set session parameters for LogMiner session
  • ora-25966 : join index cannot be based on an index organized table
  • ora-38859 : instance string (thread string) is not ready to be disabled
  • ora-03209 : DBMS_ADMIN_PACKAGE invalid file/block specification
  • ora-36837 : (XSLMGEN07) Dimension string.string!string is missing a COLUMNNAME property value
  • ora-12662 : proxy ticket retrieval failed
  • ora-30568 : cannot drop log group - nonexistent log group
  • ora-13612 : The recommendation action string,string is not valid for task string.
  • 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.