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

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).

--

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

Alex Skolnick wrote in message
<2jd0dsobarc5dq3kggr3otekhisrn2nv40_at_4ax.com>...
>I am using Oracle 8 and encountering these errors.
>
>Maybe I should start looking into alternative ways of getting the data
>from the local into the Remote DB.
>
>Any ideas?
>
>On Wed, 15 Mar 2000 22:01:13 -0000, "Jonathan Lewis"
><jonathan_at_jlcomp.demon.co.uk> wrote:
>
>>
>>It could be possible that you are doing
>>everything right. Errors in the area of 600
>>are usually indicative of Oracle bugs rather
>>than user accidents.
>>
>>Is this version 7.3 - I recall having similar
>>problems with unexpected termination
>>a couple of years ago which was down to
>>an Oracle bug.
>
Received on Thu Mar 16 2000 - 01:46:54 CST