0

Is there any Oracle metadata table that show me the created date from a specific table?

Renato Shumi
  • 198
  • 1
  • 1
  • 14

1 Answers1

0

Try this:

select object_name, created
from user_objects
where object_type = 'TABLE'
  and object_name = '...'

You can user all_objects or dba_objects instead of user_objects, depending on your privileges and on the users you are interested in

Aleksej
  • 22,443
  • 5
  • 33
  • 38