ORA-26530: unable to build materialized view refresh control list

Cause : The materialized view control list could not be constructed. This is generally the result of an error while accessing the local materialized view catalog.

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

Verify that the named materialized view(s) are properly defined and valid.

update : 25-04-2017

ORA-26530 - unable to build materialized view refresh control list
ORA-26530 - unable to build materialized view refresh control list

  • ora-12703 : this character set conversion is not supported
  • ora-30461 : 'string.string' cannot be refreshed because it is marked DISABLED
  • ora-01630 : max # extents (string) reached in temp segment in tablespace string
  • ora-10364 : Do not clear GIMH_STC_SHUT_BEGIN state during shutdown
  • ora-23611 : tablespace "string" has more than one data file
  • ora-28525 : unable to create Heterogeneous Services error message text
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-37000 : (NOTALIAS00) workspace object is not an ALIAS DIMENSION of workspace object.
  • ora-01032 : no such userid
  • ora-30356 : the specified refresh method is not supported in this context
  • ora-17613 : Failed to initialize Oracle Disk Manager library: string
  • ora-02184 : resource quotas are not allowed in REVOKE
  • ora-00353 : log corruption near block string change string time string
  • ora-29380 : resource plan string is currently active and cannot be deleted
  • ora-01718 : BY ACCESS | SESSION clause not allowed for NOAUDIT
  • ora-22308 : operation not allowed on evolved type
  • ora-38716 : Must supply an integer for the TYPE option.
  • ora-24121 : both cascade and a block range passed to DBMS_REPAIR.CHECK_OBJECT procedure
  • ora-14193 : invalid ALTER INDEX MODIFY SUBPARTITION option
  • ora-02444 : Cannot resolve referenced object in referential constraints
  • ora-01252 : cannot prevent writes - file string in recovery manager backup
  • ora-13147 : failed to generate MBR
  • ora-28359 : invalid certificate identifier
  • ora-28512 : cannot get data dictionary translations from string
  • ora-19911 : datafile string contains future changes at the incarnation boundary
  • ora-00309 : log belongs to wrong database
  • ora-36680 : (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.
  • ora-01858 : a non-numeric character was found where a numeric was expected
  • ora-01608 : cannot bring rollback segment 'string' online, its status is (string)
  • ora-01572 : rollback segment 'string' cannot be brought online, string extents exceeded
  • 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.