Printable View
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
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.
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