A ll tables in Oracle database that were created within the last 60 days Ref:  https://dataedo.com/kb/query/oracle/find-recently-created-tables select owner as schema_name, object_name as table_name, created from sys.dba_objects where object_type = 'TABLE' -- excluding some Oracle maintained schemas and owner not in ( 'ANONYMOUS' , 'CTXSYS' , 'DBSNMP' , 'EXFSYS' , 'LBACSYS' , 'MDSYS' , 'MGMT_VIEW' , 'OLAPSYS' , 'OWBSYS' , 'ORDPLUGINS' , 'ORDSYS' , 'OUTLN' , 'SI_INFORMTN_SCHEMA' , 'SYS' , 'SYSMAN' , 'SYSTEM' , 'TSMSYS' , 'WK_TEST' , 'WKSYS' , 'WKPROXY' , 'WMSYS' , 'XDB' , 'APEX_040000' , 'APEX_PUBLIC_USER' , 'DIP' , 'FLOWS_30000' , 'FLOWS_FILES' , 'MDDATA' , 'ORACLE_OCM' , 'XS$NULL' , 'SPATIAL_CSW_A...