mlogs.sql
---------------------------------------------------------------------------
-- 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
/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.
