Query to search for table in DB schema
------------------------------------------
SELECT * FROM all_tables
where owner = 'TEST_SCHEMA'
and TABLE_NAME like ('%MASKING%');
Query to find for table updates or inserts in Table DB
-----------------------------------------------------------------------
select table_owner,table_name,inserts,updates,deletes from dba_tab_modifications where table_name = 'TEST_MASKING';
Comments
Post a Comment