DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: problem_in_CREATE_MVIEW_REPGROUP

  1. #1
    Join Date
    Oct 2010
    Posts
    13

    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

  2. #2
    Join Date
    Oct 2010
    Posts
    13
    cant somebody help me out at this??????? i 've been waiting since v long...

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  4. #4
    Join Date
    Oct 2010
    Posts
    13
    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
  •  


Click Here to Expand Forum to Full Width