Yip

Want to create an exp from their old imp that is on my DB.

My querY looks something like this:

select'SELECT *FROM TABLE '||OWNER||'.'||TABLE_NAME||' WHERE NETWORK_ID<>8'
from sys.all_tab_columns
where owner in ('IAMM','IAMM_LOAD','IAMM_AUDIT')
AND COLUMN_NAME IN('NETWORK_ID','SECTION_ID')
ORDER BY owner,TABLE_NAME;

This gives a return of appr 100 queries where the deleted data is hidden on my DB which i have to exp