regsnaps.sql
--------------------------------------------------------------------------- -- Filename: regsnaps.sql -- Purpose: Lists registered snapshots (run from master site). -- Author: Chas. Dye (cdye@excitecorp.com) -- Date: 24-Jun-1998 --------------------------------------------------------------------------- column owner heading "Owner" format a8 column name heading "Name" format a20 column snapshot_site heading "Snapshot|Site" format a15 column can_use_log heading "Can|Use|Log" format a3 column updatable heading "Upd" format a3 column refresh_method heading "Refresh|Method" format a11 column version heading "Version" format a10 SELECT owner, name, snapshot_site, can_use_log, updatable, refresh_method, substr(version, 1, 8) version FROM dba_registered_snapshots /
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.