One stop Oracle Database Knowledge center for DBAs
Future of ORACLE DBA
Thursday, July 17, 2014
CHECK USER OBJECTS LAST UPDATED TIME
SELECT owner || '.' || object_name object_name, object_type, to_char(last_ddl_time,'MM-DD-YYYY HH24:MI:SS') last_ddl_time FROM dba_objects WHERE owner in ('UKIRAN') ORDER BY owner, object_type;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment