| |
 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
COLUMN
refreshed HEADING "Last Refresh"
COLUMN start FORMAT a13 HEADING "Start Refresh"
COLUMN error HEADING "Error"
COLUMN next FORMAT a13 HEADING "Next Refresh"
rem
PROMPT Percent signs are wild card
ACCEPT mv_owner PROMPT Enter the materialized view owner
ttitle "Materialized View Report for &mv_owner"
SPOOL mv_rep&db
rem
SELECT
Owner||'.'||mview_name mv, master_view,
master_link Source,
substr(query,1,query_len) query,
updatable,
update_log Log, last_refresh_date Refreshed,
DECODE(refresh_mode,'FAST','F','COMPLETE','C','FORCE','FR','COMMIT','CM'),
query
master_rollback_segment rbk
FROM dba_mviews
SEE CODE DEPOT FOR FULL SCRIPT
ORDER BY owner,mview_name;
rem
SPOOL OFF
Here is a sample listing.
Use Ref
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link:
|
