-- Query to find backup objects (tables with '_bak' or '_backup' in their names)
SELECT owner, table_name
FROM dba_tables
WHERE table_name LIKE '%_bak%' OR table_name LIKE '%_backup%';
-- Query to find backup views
SELECT owner, view_name
FROM dba_views
WHERE view_name LIKE '%_bak%' OR view_name LIKE '%_backup%';
No comments:
Post a Comment