Unable to unregister mview group
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Unable to unregister mview group

  1. #1
    Join Date
    May 2009
    Posts
    4

    Question Unable to unregister mview group

    Hi there,

    I met a problem during cleaning up a mview. MView group "ARN_SEQ" could not unregistered. How could I unregister it?

    jleu011

    SQL> select * from dba_registered_mview_groups ;

    NAME
    ------------------------------
    MVIEW_SITE
    --------------------------------------------------------------------------------

    GROUP_COMMENT
    --------------------------------------------------------------------------------

    VERSION FNAME OWNER
    -------- ------------------------------ ------------------------------
    ARN_SEQ
    TIDBSC.WORLD

    ORACLE 8 PUBLIC


    SQL> BEGIN
    2 DBMS_REPCAT.UNREGISTER_MVIEW_REPGROUP (
    3 gname => 'ARN_SEQ',
    4 mviewsite => 'TIDBSC.WORLD');
    5 END;
    6 /
    BEGIN
    *
    ERROR at line 1:
    ORA-23382: materialized view repgroup ""."" is not registered at site
    TIDBSA.WORLD
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
    ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2179
    ORA-06512: at "SYS.DBMS_REPCAT", line 57
    ORA-06512: at line 2


    SQL>

  2. #2
    Join Date
    May 2009
    Posts
    4

    Unhappy Nobody experienced?

    Nobody experienced?

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Any particular reason not to include gowner parameter?

    Please do and post *properly formatted*:

    select * from dba_objects where object_name = 'ARN_SEQ';
    Last edited by PAVB; 06-03-2009 at 10:28 AM.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  4. #4
    Join Date
    May 2009
    Posts
    4
    gowner default is PUBLIC. No difference even it's included.

    BEGIN
    DBMS_REPCAT.UNREGISTER_MVIEW_REPGROUP (
    gname => 'ARN_SEQ',
    mviewsite => 'TIDBSC.WORLD',
    gowner => 'PUBLIC');
    END;
    /


    Error starting at line 1 in command:
    BEGIN
    DBMS_REPCAT.UNREGISTER_MVIEW_REPGROUP (
    gname => 'ARN_SEQ',
    mviewsite => 'TIDBSC.WORLD',
    gowner => 'PUBLIC');
    END;
    Error report:
    ORA-23382: materialized view repgroup ""."" is not registered at site TIDBSA.WORLD
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
    ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2179
    ORA-06512: at "SYS.DBMS_REPCAT", line 57
    ORA-06512: at line 2
    23382. 00000 - "materialized view repgroup \"%s\".\"%s\" is not registered at site %s"
    *Cause: The materialized view repgroup is not currently registered at
    the master and so cannot be unregistered.
    *Action: None

    select * from dba_objects where object_name = 'ARN_SEQ';

    OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY
    ------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ---------------------- ---------------------- ------------------- ------------------------- ------------------------- ------------------- ------- --------- --------- ---------
    PUBLIC ARN_SEQ 94277 SYNONYM 2009-05-25 2009-05-25 2009-05-25:17:48:42 VALID N N N
    DBATIDBSA ARN_SEQ 98397 98397 TABLE 2009-05-25 2009-05-26 2009-05-25:17:48:41 VALID N N N

    2 rows selected

Tags for this Thread

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