Click here to Skip to main content
15,742,655 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I've created a MV, on many tables. I don't want to auto-refresh it. I just want to know whether original tables were changed or not. What is the best way to do that?
Updated 3-Nov-11 3:33am

1 solution

SELECT * FROM all_tab_modifications

Adjust the query to fit your needs.

I just realized that it might not be the latest modification of the table you're asking for, but the latest modification of the tables content.
In that case you can run this query instead:
SELECT  scn_to_timestamp(max(ora_rowscn)) 
FROM    Mytable
Share this answer
Dalek Dave 8-Nov-11 17:05pm    
Seems reasonable.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900