Re: How to get SQL commands executed on Oracle database in certain period?

qazmlp1209_at_rediffmail.com wrote:
> Is it possible to get the SQL commands executed on a Oracle database
> from a certain time?
>
> We have a system connected with Server-1 and Server-2. Server-1 uses
> Oracle RDBMS and Server-2 uses some other database for Data storage.
> In regular intervals, the application running on the System should
> fetch all the SQL commands executed on Server-1 from the last interval,
> convert if required and then apply these changes on the Server-2. I
> cannot use redo logs, as I have to apply the changes on a non-Oracle
> database. For this reason, I would like to know how exactly I can get
> the SQL commands executed on a Oracle database from a certain time(or
> in certain time period).

Note Mark's reply. Perhaps you should be looking at some third-party db-neutral replication tools. Received on Thu Oct 05 2006 - 09:54:08 CDT