Re: Refresh group

Luch wrote:
> Is there an equivlanent schema/user view to this view:
> SELECT *
> FROM SYS.rgroup$
> ;
>
> Just like there is SYS.ALL_TABLES and the equivalent USER_TABLES, I
> want the user equivalent of RGROUP$, so i can see within the user if a
> refresh group exists or not.

SQL> select name from dba_dependencies

   2 where referenced_name = 'RGROUP$'
   3 and type = 'VIEW'
   4 union
   5 select referenced_name from dba_dependencies    6 where name = 'RGROUP$'
   7 and type = 'VIEW';

NAME

DBA_REFRESH
DBA_REFRESH_CHILDREN
DBA_RGROUP

KU$_ADD_SNAP_VIEW
KU$_M_VIEW_VIEW
KU$_REFGROUP_VIEW

7 rows selected.

SQL> I'd look at the first three.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org