Re: sqlplus copy command question

From: Antony Mak <cheong_at_broadway-ps.com>
Date: Fri, 20 Jul 2001 14:55:24 +0800
Message-ID: <3b57d5de@newsgate.imsbiz.com>

Hi Michael,

Thank your for your help. I have tried it but still get the problem on all (three) SuSE linux 6.4 boxes running oracle 8.1.6.1.0.

Antony

>copy from bla/bla_at_remote to me/me_at_local insert xx_dept using select *
>from dept
>
>watch out maybe the ";" at the end of the line is the problem. Btw. if
>the table is very big
>
>set copycommit 1000 is a good idea. Maybe your rollback segments are
>blowed into pieces
>
>Regards
>Michael
Received on Fri Jul 20 2001 - 01:55:24 CDT