-
Is it possible to find out the time stamp of the creation of an object in the database, say a table, using an SQL query. I know, using the log miner we could do it by extracting information from the archived logs. My question is, whether it is possible to find out the date and time using an SQL query.
Thank you
Anil
-
select created
from user_objects
where object_type = 'TABLE'
and object_name = '...'
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|