Oracle-L: RE: SQL*Plus COPY error

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 25 Oct 2002 11:48:58 -0800
Message-ID: <F001.004F4153.20021025114858@fatcity.com>

Paul -

Hopefully you will receive more helpful advice, but I have received strange errors using the COPY command and the reply I received from Oracle support was that it was being phased out and if I didn't like errors I should write a small PL/SQL program to perform this task (give you a copy if you want it). That was 5 years ago, so obviously it hasn't disappeared. I would recommend modifying your COPY statement until you get away from the error.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, October 25, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L

I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error:

SQL> @odss/cmsr

Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 20000. (long is 20000)

ERROR:
ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA

Anyone seen this or anything like it? My environment is set up properly; i.e., errors returned by operations other than COPY display the way they're supposed to.

TIA!

Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Baumgartel
INET: treegarden_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------