Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Transaction Boundary ..
Raghavendra S. Kothamangala wrote:
> Hi,
>
> I have a requirement to do custom processing for any new
> transaction, which happens in a Oracle database.
>
> When there is a new transaction in the oracle database, how can
> I know the following information.
>
> 1. The tables involved (which were updated) in the transaction.
> 2. The sequence of the updates.
> 3. The source (user) which updated the transaction.
> 4. The start and commit time.
>
> I have to do processing on this data immediately, and update
> another database.
>
> What is the simplest way to achieve this?
>
> Suggestions and Pointers are appreciated.
>
> Thanks in Advance
> -Raghu
Without a lot more information, including Oracle version, no help is possible beyond wild guesses.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Wed May 04 2005 - 10:03:23 CDT
![]() |
![]() |