Re: Cool way to crash an Oracle database, any time, any place

I've checked this on a 817EE penguin SuSE7.0. The row gone simply into the bad file.

oli

wweaver_at_rightnow.com 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: info@cubeoffice.de # web: http://www.cubeoffice.de
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  INET: oli_at_md.transnet.de

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