 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
mv_rep.sql
rem
rem Name: mv_rep.sql
rem Purpose:Report on database Materialized views
rem Use:
From an account that accesses DBA_MVIEWS
rem
rem When Who What
rem ------- --------- ----------------
rem 5/27/93 Mike Ault Initial Creation
rem 10/10/01 Mike Ault Update to 9i
rem
SET PAGES 56 LINES 130 FEEDBACK OFF VERIFY OFF
rem
COLUMN mv FORMAT a30 HEADING "Materialized|View"
COLUMN source FORMAT a30 HEADING "Source Table"
COLUMN log HEADING "Use|Log?"
COLUMN type FORMAT a10 HEADING "Ref|Type"
Mike has
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link:
|
