find the LAST_DDL_TIME change time of an Oracle object

SQL to find the LAST_DDL_TIME change time of an Oracle object in the database.

-- Get the name, type, date of change of the DDL of a user object.

select OBJECT_NAME, OBJECT_TYPE, LAST_DDL_TIME from dba_objects where
owner not in ('SYS','SYSTEM');

Comments

Popular posts from this blog

chr function and its values - CHR and ASCII values

RMAN-06820: WARNING: failed to archive current log at primary database

ORACLE FAL_CLIENT and FAL_SERVER explained