Solved

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

Posted on 2013-11-18
3
367 Views
Last Modified: 2013-11-18
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
0
Comment
Question by:LindaC
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39656516
>>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
 
LVL 8

Author Comment

by:LindaC
ID: 39657073
Ok, thanks for the clarification.
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39657089
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question