Tuesday, 21 January 2025

Find old database backup objects and delete them to get memory back.

 -- 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