Re: transfering data

[manish singh]

well trasferring data from oracle to mysql
can be achieved in a number of ways
but real-time transfer is a thing to work at

i had made a system in which i created windows batch files to
generate data files from the oracle servers and another set
of batch jobs to read the files and populate the mysql tables
also these batch jobs can be schedeuled

if you can schedule these process finely then you can have almost real time
data updation.

aprt from these there are some tools like sqlwaya, mydbpal which can help you
but again real time updation is a ?

iam not sure if one can use triggers in oracle to update a remote
mysql database but if yes then that would be the answer to your problem
isnt it

there is another thing called
oracle heterogenous connectivity which iahavent used.