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-05-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-13858 : Invalid action name
  • ora-26709 : Streams RFS restart
  • ora-28140 : Invalid column specified
  • ora-06906 : CMX: cannot get maximum packet size from CMX
  • ora-38490 : invalid name: quotes do not match
  • ora-02448 : constraint does not exist
  • ora-02072 : distributed database network protocol mismatch
  • ora-01644 : tablespace 'string' is already read only
  • ora-06144 : NETTCP: SID (database) is unavailable
  • ora-07227 : rtneco: unable to set noecho mode.
  • ora-23430 : argument "string" cannot be NULL or empty string
  • ora-23367 : table string is missing the primary key
  • ora-24850 : failed to startup shared subsystem
  • ora-06028 : NETASY: unable to intialise for logging
  • ora-30350 : specified dimension attribute does not exist
  • ora-00113 : protocol name string is too long
  • ora-38705 : Expected block size string does not match string in log header.
  • ora-07426 : spstp: cannot obtain the location of dbs directory.
  • ora-13233 : failed to create sequence number [string] for R-tree
  • ora-19591 : backup aborted because job time exceeded duration time
  • ora-01954 : DEFAULT ROLE clause not valid for CREATE USER
  • ora-24129 : table name string does not start with string prefix
  • ora-38853 : cannot mark instance string (redo thread string) as disabled
  • ora-07681 : sou2os: An error occurred while initializing Oracle
  • ora-13267 : error reading data from layer table string
  • ora-33557 : (MAINTCHK01) You cannot string values of dimension workspace object during a loop over it.
  • ora-24359 : OCIDefineObject not invoked for a Object type or Reference
  • ora-36646 : (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.
  • ora-13515 : Error encountered during Database Usage Statistics capture
  • ora-32838 : exceeded maximum number of properties
  • 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.