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).

qazmlp1...@rediffmail.com wrote:

Well using a scheduling system of some sort is probably your answer.
On unix/linux cron is provided which is a barebones type of scheduler.
Many unix/linux shops use other 3rd party schedulers.

Windows also has a built in scheduling facility that's pretty basic.

You do realize that the SQL commands used against oracle will not
probably match exactly SQL that other databases would require don't
you?

It sounds like you will need to build something custom that will look
at the data changes in oracle and then extract and build somehow a flat
file that would contain the sql commands that you want executed on the
other database.

Is that a little kludgy? Maybe but not unlike things that people have
put in place.

Perhaps a better solution would be changes so that the applications
that run against the other database would access the relevant
information in oracle when they need that information.

qazmlp1209@rediffmail.com wrote:

Note Mark's reply. Perhaps you should be looking at some third-party
db-neutral replication tools.