Member Avatar for shapam

I am facing problem in database.

i want to select tables which have been updated from last one week..

  • 3 Contributors
  • 4 Replies
  • 164 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by seslie
Member Avatar for seslie

This is definately a very late reply but just incase some one googled and gets here.

Incase you(Shapam) are still in need of this,
First of, if you are tracking this yourself, you need to have an audit trail table. This table basically keeps records of all activities performed on various tables of your db. You should have a column that records the dates the changes were made.

This means that, you would need to write a query that inserts into the audit trail table everytime changes are made to all tables. Then you could always query the audit trail table.

Also Google Oracle auditing.

Member Avatar for shapam

thanks for ur reply but this prob already had solved...

Member Avatar for itzarun

I am facing problem in database.

i want to select tables which have been updated from last one week..

you can also use dba_objects table to get last DDL time. But to get tables based on transaction you should go for audit settings.

try this link

Member Avatar for seslie

Hello Shapam,
That's good to know, please could you post how you got the problem solved, so I and others can benefit from it? Thanks and also mark as solved once you do.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.