-
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>
-
Nobody experienced?
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|