What objects where modified / created by a person, based on last_ddl and created from all_objects

Hi experts.
Audits:

What objects where modified / created by a person, based on last_ddl and created from all_objects list that I have uploaded.
I know that the running of the dbms_stats can alter the last_ddl, what other thing may affect this date?
last-ddl.txt
created.txt
LVL 8
LindaCAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
In answer to your question, I believe only DDL performed against the object can change this value.

Oracle Support is likely the only folks that can confirm this with 100% certainty.
0
 
slightwv (䄆 Netminder) Commented:
>>I know that the running of the dbms_stats can alter the last_ddl

It can?  I could not think of a reason it would and the below test case doesn't change it on my 10.2.0.3 database.

SQL> select last_ddl_time from user_objects where object_name='TAB1';
11/13/2013 10:54:54

SQL> exec dbms_stats.gather_table_stats('SCOTT','TAB1');

PL/SQL procedure successfully completed.


SQL> select last_ddl_time from user_objects where object_name='TAB1';
11/13/2013 10:54:54

Open in new window

0
 
LindaCAuthor Commented:
Ok, thanks for the clarification.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.