Click here to Skip to main content
15,892,927 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?
Posted
Updated 3-Nov-11 3:33am
v2

1 solution

Try:
SQL
SELECT * FROM all_tab_modifications

Adjust the query to fit your needs.

<edit>
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:
SQL
SELECT  scn_to_timestamp(max(ora_rowscn)) 
FROM    Mytable
</edit>
 
Share this answer
 
v3
Comments
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