Re: Storing transactions

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 30 Nov 2002 00:10:55 +1000
Message-ID: <XsJF9.86400$g9.243270@newsfeeds.bigpond.com>

"Laurent RUHLMANN" <lruhlmann_at_ingesoft.fr> wrote in message news:as7get$e15$1_at_s1.read.news.oleane.net...
> Hello,
>
> Is it possible with Oracle to store transactions in a log to be able to
see
> transactions historic
>
> Laurent
>

Hi Laurent,

Yes.

I guess you could always write a trigger that stores relevant details in a separate table/transaction log.

Or you could the "transaction log" that is automatically maintained by Oracle, that being the redo logs and use logmnr to extract relevant details.

Cheers

Richard
>
Received on Fri Nov 29 2002 - 08:10:55 CST