cx-oracle-users

[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

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

[Paul M. <p.f...@gm...>]

On 2 November 2011 03:22, Victor Hooi <vic...@ya...> wrote:
> 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?

Check out cx_OracleTools: http://cx-oracletools.sourceforge.net/ -
there's a CopyData tool.

Note - I haven't actually used these myself, but they seem to do the
sort of thing you're after.

Paul.

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

[Mark H. <mh...@pi...>]

On 11/2/11 2:49 AM, Paul Moore wrote:
> On 2 November 2011 03:22, Victor Hooi<vic...@ya...>  wrote:
>> 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?
>
> Check out cx_OracleTools: http://cx-oracletools.sourceforge.net/ -
> there's a CopyData tool.
>
> Note - I haven't actually used these myself, but they seem to do the
> sort of thing you're after.

cx_OracleTools are amazing.  Anybody not using them should check them out!