Re: SQL*Plus Copy Command Problem

"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message news:<7361fed8e32ab515339ac24536b46ba2.38849_at_mygate.mailgate.org>...
> I am trying to insert some rows into a table containing a LONG, selected
> from a remote DB. It works ok in Unix (Oracle 8.1.7.2.0 on AIX), but
> not when using the client SQL*PLus (NT). The Oracle error message shown
> is not listed on their website. At first I thought the problem was that
> it couldn't find the message, but that the command was working. But
> that's not the case, the rows aren't inserted.
>
> Any advice?
>
>
> -- Unix version
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
> JServer Release 8.1.7.2.0 - 64bit Production
>
> SQL> !cat copylong.sql
> SPOOL copylong.log
> SET AUTOTRACE OFF
> SET LONG 2000
>
> COPY FROM myuser/xxxx_at_remotedb -
> INSERT MY_TABLE -
> USING SELECT * FROM MY_TABLE;
>
> SPOOL OFF
>
> SQL> @copylong
>
> Array fetch/bind size is 15. (arraysize is 15)
> Will commit when done. (copycommit is 0)
> Maximum long size is 2000. (long is 2000)
> 9 rows selected from MYUSER_at_REMOTEDB.
> 9 rows inserted into MY_TABLE.
> 9 rows committed into MY_TABLE at DEFAULT HOST connection.
>
> SQL>
>
>
> -- NT error:
>
> 10:38:40 SQL> @copylong
>
> ERROR:
> ORA--3922282: Message -3922282 not found; product=RDBMS; facility=ORA

HI,

USE DOS VERSION OF SQLPLUS.I THINK GUI VERSION HAS BUG. I HAD SAME PROBLEM AND USE DOS VERSION AND it works fine for me.

e.g goto cmd.exe(dos prompt)
Type --> sqlplus scott/tiger_at_database

and then execute copy command. Received on Tue May 14 2002 - 19:08:11 CDT