Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to detrermine the last update to the data in a table?

unknown-2973982Feb 23 2016 — edited Feb 24 2016

Hello Gents and Gals,

I am been tasked to find out when the last time someone updated the data in a table.

Now, I know how to find out the last time a table has had DDL changed on it.

Like this here:

select OBJECT_NAME,LAST_DDL_TIME from dba_objects where OBJECT_NAME = 'tablename';

But, How can you determine what user updated what "data" inside the table?

Thanks,

Lady Allora...

This post has been answered by unknown-951199 on Feb 23 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2016
Added on Feb 23 2016
34 comments
19,047 views