Hi forum,
Is there some way to query the database and find out the tables that were
updated/ Inserted in the last 1 hr?
Now why this is a requirement.
We have recently acquired a product developed by another vendor.
The application is in Java and the database is Oracle 10G.
A commit in a Java front end program might trigger inserts/updates in multiple tables.
Its difficult to run through the Java code to identify the inserts/updates
coz the code runs over 1000's of lines spread across several modules.
I thought it would be better if simple query can be run after the commit in Java so that
we get to know exactly what are the tables that were affected.
Pls share your thoughts on this. Pls do let me know if you need any more clarification.
SQL >SELECT BANNER FROM V$VERSION;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
Thanks in advance,