CODEWITHSUNDEEP
oracle-database
Ketan Jariwala
Ketan Jariwala

Reputation: 225

Oracle : How to get Last DDL Updated Time

I have tried the following SQL:

SELECT * FROM all_objects

But it also update LAST_DDL_TIME column of above table whenever any table grant is given any other schema.

I want Last DDL update time for table Alter only.

Upvotes: 4

Views: 8936

Answers (3)

David Aldridge
David Aldridge

Reputation: 52336

If you use trigger to monitor DDL, you are essentially replicating functionality already provided through Oracle Auditing.

http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_4007.htm

There is 10g-related guidance here: https://oracle-base.com/articles/10g/auditing-10gr2

Upvotes: 1

HaRdik Kaji
HaRdik Kaji

Reputation: 425

Ketan, I think DDL Triggers will solve your problems.

Find out more on this : http://www.dba-oracle.com/t_ddl_triggers.htm

Upvotes: 4

Rahul Tripathi
Rahul Tripathi

Reputation: 172378

You can try this:

SELECT object_name, object_type, last_ddl_time
FROM dba_objects 
WHERE owner = <<table owners name>>
AND object_name = 'yourTableName'

Upvotes: 0

Related Questions