Read from database, write to another database, simultaneously

[Bjoern Schliessmann]

Sean Davis wrote:

> I solved this problem by creating a temporary file as an
> intermediary, but why wait for Oracle to finish dumping data when
> I can potentially be loading into postgres at the same time that
> the data is coming in?  So, I am actually 
> looking for a solution to this problem that doesn't require an
> intermediate file and allows simultaneous reading and writing,
> with the caveat that the data cannot all be read into memory
> simultaneously, so will need to be buffered.

The functions you use don't seem very suited for such a
streaminglike task.

Regards,


Björn

-- 
BOFH excuse #282:

High altitude condensation from U.S.A.F prototype aircraft has
contaminated the primary subnet mask. Turn off your computer for 9
days to avoid damaging it.