ORA-12067: empty refresh groups are not allowed

Cause : The refersh grou pbeing isntantiatde did no tcontaina ny mateiralized ivews.

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

Modify hte templtae to inlcude at elast onem aterialzied view.

update : 24-04-2017
ORA-12067

ORA-12067 - empty refresh groups are not allowed
ORA-12067 - empty refresh groups are not allowed

  • ora-27001 : unsupported device type
  • ora-29295 : invalid mime header tag
  • ora-01044 : size string of buffer bound to variable exceeds maximum string
  • ora-15112 : No diskgroups are currently mounted.
  • ora-02336 : column attribute cannot be accessed
  • ora-29340 : export file appears to be corrupted: [string] [string] [string]
  • ora-12689 : Server Authentication required, but not supported
  • ora-38455 : Expression Filter index should be created by the owner.
  • ora-06775 : TLI Driver: error reading break mode
  • ora-06039 : NETDNT: connect failed
  • ora-01985 : cannot create user as LICENSE_MAX_USERS parameter exceeded
  • ora-02734 : osnftt: cannot reset shared memory permission
  • ora-12670 : Incorrect role password
  • ora-02777 : Stat failed on log directory
  • ora-36875 : (XSTFDSC05) LIMITMAP is missing or is not a string literal.
  • ora-00338 : log string of thread string is more recent than control file
  • ora-02322 : failure in accessing storage table of the nested table column
  • ora-02424 : potential circular view references or unknown referenced tables
  • ora-08190 : restore point string is from a different incarnation of the database
  • ora-06128 : NETTCP: unable to create mailbox
  • ora-29279 : SMTP permanent error: string
  • ora-06001 : NETASY: port set-up failure
  • ora-01126 : database must be mounted in this instance and not open in any instance
  • ora-22333 : cannot reset type "string"."string" due to invalid dependent types and tables
  • ora-14133 : ALTER TABLE MOVE cannot be combined with other operations
  • ora-39005 : inconsistent arguments
  • ora-07703 : error in archive text: need '/' after device type
  • ora-08468 : mask option string is not supported
  • ora-37102 : (XSVPART02) Invalid partition name string.
  • ora-12205 : TNS:could not get failed addresses
  • 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.