DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Need to findout all the snapshots that are using a log

  1. #1
    Join Date
    Apr 2002
    Posts
    61

    Question

    I need to find out all the databases that are using one of my tables via snapshot/materialized view. I have the snapshot log for this table. Initially I had one database(X) snapshoting it. Now, we need to make some changes to this base table. So, we dropped the snapshot from the database(X) and trying to drop the snapshot log table from my database, but it won't let me do it. It says that somebody is using this log.
    Please help if you know there is a systable, view, etc from where I can find who is snapshoting my table.
    Thanks in advance for your help.

  2. #2
    Join Date
    Apr 2002
    Posts
    61

    Figured it out

    Oracle automatically registers information about a read-only snapshot at its master site when its created. It unregisters it when you drop a snapshot.

    The view dba_registered_snapshots holds this information on the master site.

    Name Null Type
    -----------------------------------------
    OWNER NOT NULL VARCHAR2(30)
    NAME NOT NULL VARCHAR2(30)
    SNAPSHOT_SITE NOT NULL VARCHAR2(128)
    CAN_USE_LOG VARCHAR2(3)
    UPDATABLE VARCHAR2(3)
    REFRESH_METHOD VARCHAR2(11)
    SNAPSHOT_ID NUMBER(38)
    VERSION VARCHAR2(17)
    QUERY_TXT LONG

Posting Permissions

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


Click Here to Expand Forum to Full Width