Oracle Tips by Burleson
Chapter 7 Oracle Storage and Object
COLUMN log_owner FORMAT a10 HEADING "Owner"
COLUMN master FORMAT a20 HEADING "Master"
COLUMN log_table FORMAT a20 HEADING "Materialized View"
COLUMN trigger FORMAT a20 HEADING "Trigger Text"
COLUMN current HEADING "Last Refresh"
log_owner, master, log_table table,
log_trigger trigger, rowids, filter_columns filtered,
object_id id, sequence seq,Include_new_values new
ORDER BY 1;
SET FEEDBACK ON
These reports provide the DBA with hard-copy
documentation of all materialized views and materialized view logs
in the database. Each can be made more restrictive by using WHERE
clauses, by selecting a specific set of values such as owner or
log_owner, type, or date since last refresh (last_refresh > &date or
current_snapshots > &date).
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link: