Error while creation of MView Repobject
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Error while creation of MView Repobject

  1. #1
    Join Date
    Dec 2005
    Posts
    6

    Error while creation of MView Repobject

    Hi!
    I am trying to implement Materialized View replication in my environment. Every thing is done fine, but When i am trying to create MView repobject, i am getting the following error:

    ERROR at line 1:
    ORA-23454: flavor not defined for object group "PUBLIC"."GROUP1"
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

    ..................

    My database version is Oracle 9.2.0.5.0 and OS version : RHEL AS 3.0.

    Thanks & Regards,

    PMR

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Code:
    oerr ora 23454
    23454, 00000, "flavor %s not defined for object group \"%s\".\"%s\""
    // *Cause: The given object group does not contain a (published) definition
    //          of the specified flavor.
    // *Action: Check the spelling of the flavor name.  Ensure the flavor has
    //          been defined (and published) for the object group.

  3. #3
    Join Date
    Dec 2005
    Posts
    6
    Hi!
    I have seen that reference and checked whether my object group has any flavor defined and published by querying the repcat$_flavors view.
    In that my refresh group has a flavor_id (-1) and also it has been published(y).
    Any thing more i have to do?

    Thanks & Regards
    PMR

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width