Learning Oracle
Pages
Home
About US
Disclaimer
Privacy Policy
Contact US
Saturday, March 25, 2017
To check all recent DDL modifications
To check all recent DDL modifications
select owner, object_type, object_Name, Timestamp Last_DDL from DBA_OBJECTS where sysDate - TO_DATE(TimeStamp,'YYYY-MM-DD:HH24:MI:SS') < 1 order by Owner, Object_Name;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment