[cx-oracle-users] Copying tables between two schemas? SQ*PLUS COPY?

[Victor H. <vic...@ya...>]

Hi,

We have two separate schemas on different Oracle database instances, and we
have a need to copy the records from certain tables from one to the other.

Due to internal regulations, creating a database link between them isn't an
option - so I suppose that rules our using INSERT INTO...SELECT, right?

Previously, we were using SQL*PLUS's COPY extension:

http://www.oracleutilities.com/SQLPLus/copy.html

and this has worked really well.

However, now we'd like to automate this, and so I figured cx_Oracle would
be the way to go. However, I don't think I can use COPY from cx_Oracle
since it's SQL*PLUS specific (
http://stackoverflow.com/questions/7963441/using-sqlplus-copy-from-inside-cx-oracle
).

Is there any way at all to get COPY to work from cx_Oracle? Or any other
way to achieve the same thing just as elegantly, and not iterate through
records?

Cheers,
Victor