Re: How to detect the change of a table?

I have been thinking about the same. However, I doubt that you can store the information in one central Audit table. That is: when you have updated the row in the audit table that says that in table A something has changed, then other sessions can not make changes to table A until the first session issues a commit. As long as no commit has been issued, the row for table A in the central Audit table will be locked.

So, I guess the best solution is to write a trigger that updates extra columns, like last_update_date and last_updated_by in the table A itself. Or you'd have to take a look at Oracle standard auditing features, which I never used.

Arjan. Received on Thu Jul 23 1998 - 00:18:15 CDT