there is no direct method as far as I know. you have following options:
1. Turn audit on
2. Use a trigger.
3. Check if the table has any date field, which application is updating(app dependent)

-----Original Message-----
From: Ron Krockett [mailto:[Email Address Removed] Friday, January 31, 2003 10:20 AM
To: LazyDBA.com Discussion
Subject: how to find table updated time/date


Hello all..

I need to find out at what time a given table has been updated with date and
time ?...

I have some 60 tables, and want to find out thich tables are updated.

Is there a way i can find that out ?..

Really appreciate it
thanks
Ron





_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail


--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page