DB Objects List

Hi All,

I was wondering if we have any way of getting a list of objects (Tables ofcourse) that got affected in the past 'n' minutes. I am aware of the Audit Trail facility, which has to be manually set; I was looking at something at core DB level functions that keep track of the changes to the Tables.

Regards,
Engi....

Look at LAST_DDL_TIME column in DBA_OBJECTS table.

Hi shailesh,

I think i need to rephrase my query; thoroughly confused everyone. What I am looking for is the object list which were affected due one of the DML Operations. What Last_ddl_time gives is the date on which the structure was altered someway or the other [if i am not wrong]. I need something like Last_DML_Time.

Hope now I am clear with my requirement. Anyways thank you for the earlier reply.

Regards
Engi

I don't think you can do that without using Audit Trail (either Oracle provided or your own)

Thanks Shailesh..... and I am doomed....

Guess have to manually see every table to see if there was any change...

:-(

Regards
Engi

On insert, delete or update.

Indeed this is a personal way of tracking the changes, but it might lead u somewhere.
With the right packages and mail configuration on the server u might even get to e-mail u the changes on a daily basses.

good luck

if you are using 9.2.0 you could look into configuring STREAMS for getting this information.

Hi

Hi
Alter table <table name> monitoring;

the view user_tab_modifications lists out number of updates ,inserts and deletes performed.
The TIMESTAMP column indicates the last time the data has been changed.
But the view is affected only after certain time of DML action due to performance reasons.

Hope this helps you