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>