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.

hostgator