Re: Updating a remote table with data from a Local Table

Start with a pair of small simple tables. Send a few rows at a time and commit.

Increase the number of rows.
Increase the number of columns.

Does is break at any particular type
of scale.

The code I use is literally of the form:

    insert into userB.tableX_at_dba_2
    select *
    from userA.tableX
    where key_col between 10000 and 11999     ;

    commit;

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Alex Skolnick wrote in message
<3d42dsgohkefghq8rtoa5ro9jmac3f367b_at_4ax.com>...
>The two systems are running identical os's and software. No
>perticular trace file.
>
>Any info on how I can move my data from one table to another would be
>greatly appreciated.
>
>On Thu, 16 Mar 2000 07:46:54 -0000, "Jonathan Lewis"
><jonathan_at_jlcomp.demon.co.uk> wrote:
>
>>
>>How much data are you moving in one shot,
>>I've just implemented a data-pump type of
>>mechanism on 8.0.5 on NT which does exactly
>>this inside a PL/SQL loop. I push 1,5,00 rows
>>per second, committing in batches of 10,000
>>to 20,00 for a total of a couple of million rows
>>at a time. No problems (yet).
>>
>>Any difference between source and
>>target platforms ? Any peculiar trace files
>>on the target ? especially network trace
>>files (in $ORACLE_HOME/network/trace
>>possibly).
>
Received on Thu Mar 16 2000 - 13:46:30 CST