Home » Server Options » Replication » problem_in_CREATE_MVIEW_REPGROUP (oracle 10.2.0.1.0, win xp)
problem_in_CREATE_MVIEW_REPGROUP [message #496337] Sat, 26 February 2011 23:58
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
hi all,

i have 2 databases, master HBFP, and its materialized view HBFM. i have created the master group but mv_repgroup is giving me problems. the copy of the spool is as below:

SQL> conn mvadmin/mvadmin@hbfm
Connected.
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
3 gname => 'hamza_repg',
4 master => 'hbfp',
5 propagation_mode => 'ASYNCHRONOUS' );
6 END;
7 /
BEGIN
*
ERROR at line 1:
ORA-23313: object group "PUBLIC"."HAMZA_REPG" is not mastered at HBFP.REGRESS.RDBMS.DEV.US.ORACLE.COM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2456
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1779
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
ORA-06512: at "SYS.DBMS_REPCAT", line 1262
ORA-06512: at line 2


SQL> CONN HAMZA/HAMZA@HBFP
Connected.
SQL> ED
Wrote file afiedt.buf

1 BEGIN
2 DBMS_REPCAT.CREATE_MASTER_REPGROUP (
3 gname => 'hamza_repg' );
4* END;
SQL> /
BEGIN
*
ERROR at line 1:
ORA-23374: object group "PUBLIC"."HAMZA_REPG" already exists
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 798
ORA-06512: at "SYS.DBMS_REPCAT", line 548
ORA-06512: at line 2
------------------------------------------------------------------------------------------------------------------------------------- ----------------------------

so at master hamza_repg already exists if i try to recreate it but at mv_site when i reference it via CREATE_MVIEW_REPGROUP. it says that hamza_repg is not mastered. i consulted Database Error Messages 10g but i couldnt understand:


ORA-23313: object group "string"."string" is not mastered at string
Cause: The group name is null, the group name is misspelled, the invocation
database is not a master, or the invocation database does not believe the given
database is a master.
Action: If the given group name was correct, connect to a current master and retry
the request, make the invocation database a master with add_master_database, or
use switch_mview_master if the invocation database is a materialized view site.


please help me at this...

i use Release 10.2.0.1.0

regards



Previous Topic: problem_in_orcle_net
Next Topic: How much amount of data over network
Goto Forum:
  


Current Time: Thu Mar 28 12:20:15 CDT 2024