Re: copy command in SQL*Plus 8.1.7

In article <5g45mtsh2ih91j5p79ppqfrklddnd6l5kh_at_4ax.com>, Dino says...
>
>Dear all,
>
>I encountered strange errors when using copy command in SQL*Plus 8.1.7
>(Oracle 8.1.7 EE for NT/2K). For example,
>
>SQL> copy from dm_admin/dm_admin_at_twdm_prod replace tb_products using
>select * from tb_products;
>
>Array fetch/bind size is 15. (arraysize is 15)
>Will commit when done. (copycommit is 0)
>Maximum long size is 80. (long is 80)
>
>ERROR:
>ORA--1663296096: Message -1663296096 not found; product=RDBMS;
>facility=ORA
>
>Note that the error number is negative.
>
>I checked Metalink and found this: (Oracle technical support also says
>this is a known but not fixed bug)
>
><METALINK begin>
>
>Bookmark Fixed font Go to End
>
>Doc ID: Note:145366.1
>Subject: COPY Command in SQL*Plus Causes ORA--3929178 or Dr. Watson
>Type: PROBLEM
>Status: REVIEWED
> Content Type: TEXT/PLAIN
>Creation Date: 14-MAY-2001
>Last Revision Date: 14-MAY-2001
>
>

.....

><METALINK end>
>
>Therefore, I have the following choices:
>1.use create table as... instead of copy...
>2.use SQL*Plus 8.0.5 when using copy
>

choice 3)

use character mode sqlplus.exe as the note stated instead of sqlplusw.exe. sqlplus.exe doesn't suffer from this

>I think this problem only happens in Oracle NT/2K, but not Unix's.
>Anyone has comments? Thanks.
>
>Dino
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp