April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- Filename: mlogs.sql
-- Purpose: Generates SELECT statements to find count of entries in all
-- snapshot logs.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 27-May-1998
---------------------------------------------------------------------------
SELECT
'SELECT count(*) FROM '||lower(owner)||'.'||lower(table_name)||';'
FROM dba_tables
WHERE table_name like 'MLOG$_%'
AND owner not like 'SYS%'
ORDER BY owner, table_name
/