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@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@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@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@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
