It sounds like you are after, most likely, auditing or else possibly system events. Both of these are available in v9 and well documented in the manuals.
cheers
I looked around allot to see what the best way was to keep a record of all dml's on a table. I found some triggers but what im really looking for is some dbms package or something.
I can not find anything, so i don't think they excist. Can anyone tell me if there are or does anyone have a very nice trigger to do this
What i expect from the tigger and what this one does not give me is that it also logs the user and system that did the dml.
Its a solaris 9.206.0 db
Thanks allot
Vincent
-- Niall Litchfield Oracle DBA http://www.orawin.info