Unable to unregister mview group

[jleu011]

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>

[jleu011]

Nobody experienced?

[PAVB]

Any particular reason not to include gowner parameter?

Please do and post *properly formatted*:

select * from dba_objects where object_name = 'ARN_SEQ';

[jleu011]

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