Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tracing a table
You may be able to use a trigger to do this.
Sbaiz wrote:
> Hi all,
>
> I'm searching any utility that permits tracing the following operations:
> I'd like to trace a sigle operation (just like INSERT, UPDATE, DELETE)
> performed on a table (a generic table <X>) and to trace the data too.
>
> I want to read, from somewhere, information just like that:
> (Date_operation, Type_operation, columns_record_1)
> (Date_operation, Type_operation, columns_record_2)
> ...
> (Date_operation, Type_operation, columns_record_n)
> where:
> Date_operation is the date when the operation is performed
> Type_operation is any INSERT, UPDATE, DELETE code (for example 'I', 'M',
> D')
> columns_record is all the data of the record.
>
> Is there anybody that can help me out?
> Thanks in advance.
> SbaizP.
Received on Tue Apr 13 1999 - 05:00:40 CDT