SQL> SELECT object_name, created
2 FROM dba_objects
3 WHERE created > sysdate - 100
4 AND object_type = ‘TABLE’
5 AND owner = ‘HR’;
OBJECT_NAME CREATED
--------------- ---------
REGIONS 09-MAY-13
LOCATIONS 09-MAY-13
JOB_HISTORY 09-MAY-13
JOBS 09-MAY-13
EMPLOYEES 09-MAY-13
DEPARTMENTS 09-MAY-13
COUNTRIES 09-MAY-13
7 rows selected.