Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    8

    Unanswered: Materialized view groups

    Hi,

    I am trying to reverse engineer an existing system and the database component of the system has materialized views that are grouped.

    Each night these groups are refreshed using the dbms_refresh.refresh command. I can see on the database which materialized views exists but I can't find out which groups they are in. Is there a table or view that lists the groups and which materialized views are in those groups?

    Cheers for any information you can provide.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Not sure, but maybe the view
    DBA_REGISTERED_MVIEW_GROUPS
    contains that information.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    dba_refresh
    dba_refresh_children
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Nov 2006
    Posts
    8

    Talking

    Cheers, that is spot on, you have secured my sanity for the next 5 minutes at least.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •