Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Cool way to crash an Oracle database, any time, any place

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

From: Weaver, Walt <>
Date: Mon, 07 May 2001 16:37:36 -0700
Message-ID: <>

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

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

Please see the official ORACLE-L FAQ:

Author: Weaver, Walt

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: (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 Mon May 07 2001 - 18:37:36 CDT

Original text of this message