Does anyone have a script to reverse engineer read-only snapshots?
TIA
Printable View
Does anyone have a script to reverse engineer read-only snapshots?
TIA
How about using Replication Manager-> configuration -> snapshots
Will give you the scripts. Is this what you wanted?
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
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