I've checked this on a 817EE penguin SuSE7.0. The row gone simply into the
bad file.
oli
[EMAIL PROTECTED] wrote
> Just thought I'd share what I learned today with everyone. This is Oracle
> 8.1.7 on a VA Linux 4450, Linux Red Hat 6.2. I'm migrating customers from
> MySQL to Oracle, using Sqlloader to load the data into Oracle.
>
> In one table I have the following column: C$NOTES VARCHAR2(4000)
>
> In my Sqlloader script I have an entry: C$NOTES CHAR(4000)
>
> When I ran Sqlloader about 130 out of 35,000 rows were not loaded due to a
> "inserted value too large for column" error on C$NOTES.
>
> So, just for grins I changed the Sqlloader entry to C$NOTES CHAR(40000).
>
>
> So, just for grins I changed the Sqlloader entry to C$NOTES CHAR(40000).
>
> When I run Sqlloader for the table with this value, it crashes the database
> every time with an ORA-600 [4620] [] [] [] [] [] error. Every dang time.
> Pmon just gives up the ghost, man. Shuts the door and turns off the lights.
> Dies a horrible death.
>
> Now, obviously I created this problem myself, but it seems to me that
> Oracle
>
> should be able to handle this a bit more gracefully than it does. :>)
>
> Anybody else ever see this? I've logged an iTar on MetaMidget to inform the
> authorities of the problem. My cursory search on MetaMidget uncovered
> absolutely no evidenct that anyone knows about this.
>
> --Walt Weaver
> Bozeman, Montana
--
Oliver Artelt
Oracle Certified DBA
cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oliver Artelt
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).