-
problem_in_CREATE_MVIEW_REPGROUP
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
-
cant somebody help me out at this??????? i 've been waiting since v long...
-
not sure if it works as i have not tested ..
how about using this in the procedure?
master => 'HBFP.REGRESS.RDBMS.DEV.US.ORACLE.COM',
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
does it make any damage to keep the name of the materialized view same as the master table??? does it make any confusion for the oracle whether to add the master table or the materialized view???
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPOBJECT (
3 gname => 'hamza_repg',
4 sname => 'hamza',
5 oname => 'donor',
6 type => 'SNAPSHOT',
7 min_communication => TRUE);
8 END;
9 /
PL/SQL procedure successfully completed.
SQL> BEGIN
2 DBMS_REFRESH.ADD (
3 name => 'mvadmin.hamza_refg',
4 list => 'hamza.donor',
5 lax => TRUE);
6 END;
7 /
PL/SQL procedure successfully completed.
>>>>>>>>since the name of the master table and this materialized view is same, is it the originating problem????
i kept the same names so as to use the same forms for both the master site and the materialized view site... i am using it but i cant use refresh group now...
is there any way out????
regards...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|