I have already developed an application front-end Form 6 and back-end Oracle 8i and it is running. It has 45 tables and I have created these tables in user sham. I would like to take backup only when any action(insert,update,delete) has taken place in any of the 45 tables.
Now I don't like to alter all the triggers or create triggers to sort out this problem. I mean create triggers or alter triggers and in it for every action(insert,update,delete) insert/update in a table values sysdate(date and time) so that I can compare this with the last backup(date and time).
Is there any way to do the above.
Thanks in advance