Oracle-L: COPY command in 9i

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Thu, 04 Apr 2002 13:48:24 -0800
Message-ID: <F001.0043C01E.20020404134824@fatcity.com>

Can anyone perform a similar test for me ? Some really cute results here:

SQL> select * from v$version;

BANNER

Oracle9i Enterprise Edition Release 9.0.1.2.1 - Production
PL/SQL Release 9.0.1.2.1 - Production
CORE 9.0.1.2.0 Production
TNS for 32-bit Windows: Version 9.0.1.2.0 - Production NLSRTL Version 9.0.1.2.0 - Production

SQL> conn system/manager
Connected.
SQL> COPY FROM SYSTEM/MANAGER_at_DB9 -
> CREATE DEMO (BLAH) -
> USING SELECT 'X' FROM DUAL;
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--18971416: Message -18971416 not found; product=RDBMS; facility=ORA

(Now there's an interesting error number!)

SQL> set arraysize 1
SQL> set long 50000
SQL> COPY FROM SYSTEM/MANAGER_at_DB9 -

> CREATE DEMO (BLAH) -
> USING SELECT 'X' FROM DUAL;
Array fetch/bind size is 1. (arraysize is 1) Will commit when done. (copycommit is 0) Maximum long size is 50000. (long is 50000) Table DEMO created.

   1 rows selected from SYSTEM_at_DB9.
   1 rows inserted into DEMO.
   1 rows committed into DEMO at DEFAULT HOST connection.

(So it looks like arraysize etc could be the workaround - but there is no rhyme or reason to this - in other tests it worked UNTIL I changed arraysize. Similarly, straight after the above, I repeat the test to a different table name...)

SQL> COPY FROM SYSTEM/MANAGER_at_DB9 -
> CREATE DEMO2 (BLAH) -
> USING SELECT 'X' FROM DUAL;
Array fetch/bind size is 1. (arraysize is 1) Will commit when done. (copycommit is 0) Maximum long size is 50000. (long is 50000)

ERROR:
ORA-03114: not connected to ORACLE

No such problems on Solaris 9.0.1.3 - can anyone reproduce under NT 9.0.1.2 if they've got it?

Charming eh?

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Apr 04 2002 - 15:48:24 CST