Reverse Engineer CREATE SNAPSHOT script
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Reverse Engineer CREATE SNAPSHOT script

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    155

    Reverse Engineer CREATE SNAPSHOT script

    Does anyone have a script to reverse engineer read-only snapshots?


    TIA

  2. #2
    Join Date
    Jan 2001
    Posts
    642
    How about using Replication Manager-> configuration -> snapshots

    Will give you the scripts. Is this what you wanted?
    There is always a better way to do the things.

  3. #3
    Join Date
    Sep 2000
    Posts
    155
    I am looking for a script (sql script). We do not have Replication Manager. A script that we can run to reverse engineer our snapshots/materialized views periodically. We want to keep these CREATE SNAPSHOT scripts up-to-date just in case if we need to re-create/restore the snapshots.


    TIA

  4. #4
    Join Date
    Jan 2001
    Posts
    642
    If you are using oracle 9i, you can use the dbms_metadata package to do so.

    If on 8i, check DBA_SNAPSHOTS FOR QUERY.

    HTH
    Badrinath
    There is always a better way to do the things.

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