Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus Copy Command Problem
What versions of SQL*Plus you're using in both cases? The copy command
is built into the SQL*Plus application so that can make a difference.
I've seen many problems with copy with different versions of databases
and SQL*Plus.
Richard
Buck Turgidson wrote:
>
> 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
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue May 14 2002 - 13:41:05 CDT