Oracle when was table last updated

We will be share the sample sql query which helps to find the last modified date of a table in oracle. We can find that , when the last change happened for a table in oracle. This helps to keep track on the latest changes for DB Tables. This is one of useful sql query for any DB Administrator.

Here below is the detail about How to find the last modified date of a table in oracle. I've missed that pseudocolumn. What is a row is deleted? How can I find out? Ask your DBA about auditing. Sadly, "Asking the DBA" tend's to be rather complicated. They are really paranoid about changing stuff. I do understand them. If anything is wrong with this db, things tend to get ugly. This would require you to gather statistics on the table first, since it only shows changes after the last gather statistics.

Sounds interesting. Can you include an example of creating a hash for a table? Mark Brady Mark Brady. Hopefully it will be in the future. Would you consider that "Special Admin Stuff"?

It would be better to describe what you're actually doing so you get clearer answers. Tony Andrews Tony Andrews k 20 20 gold badges silver badges bronze badges. That's the problem: I don't just write the data but I need to process it in a complicated way.

This takes several hours and this what I'm trying to avoid. TMtech TMtech 6 6 silver badges 13 13 bronze badges. Renjith 5, 9 9 gold badges 29 29 silver badges 42 42 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? No one has contributed to this discussion in over 8 years. Are you sure you have something valuable to add to revive the existing conversation? Consider starting a new topic instead. Otherwise, please be thoughtful, detailed and courteous, and adhere to our posting rules. Edit Preview. H1 H2. Post Reply. Insert Code Block. Share Post.

Permanent Link.