-
How can I find the date the last change was made to any object in my db?
Thanks,
SM
-
select owner, object_type, object_name, created, last_ddl_time
from dba_objects
created = date of creation
last_ddl_time = date of last DDL modification
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
|