Does anybody know how to get Date & Time stamp when Oracle View was updated/created ?
Thanks for help, Jan
Printable View
Does anybody know how to get Date & Time stamp when Oracle View was updated/created ?
Thanks for help, Jan
SELECT object_name, created, last_ddl_time AS last_modified
FROM dba_objects
WHERE object_type='VIEW
AND owner = 'THE_OWNER'
AND object_name = 'THE_VIEW';