Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

last_ddl_time in dba_objects table Oracle

what does column "last_ddl_time" in table "dba_objects" really mean? what causes the change of the date in this column?

We are testing this as part of change management in Oracle and im not sure what this column really represents.

Thank you in advance!

regards

like image 375
MatNew Avatar asked Sep 17 '25 01:09

MatNew


1 Answers

According to the docs:

Timestamp for the last modification of the object resulting from a DDL statement (including grants and revokes)

So creating a table, altering a table, rebuilding an index, granting access and so on and so forth, depending on the object type.

Did you have a more specific question, or was that it?

like image 194
ewramner Avatar answered Sep 19 '25 19:09

ewramner