SQL*LOADER error message

From: <tk_tang_at_hotmail.com>
Date: Tue, 26 May 1998 11:16:14 GMT
Message-ID: <6ke89u$bh1$1@nnrp1.dejanews.com>

Hello,

I am using Oracle 7 Workgroup Server Ver 7.1.4.3.4 for Netware. I got below error messages
when I upload a 12MB data file to IMMASTER. My rollback segment size is created in 10MB.
Is it happen due to my rollback segment too small? Do I possible to turn off rollback segment
feature in SQL*Loader?

SQL*Loader-926: Oci error while executing deleting (due to REPLACE keyword)

                             from table for table IMMASTER

ORA-01562: failed to extend rollback segment (id = 5) ORA-01628: max # extents (121) reached for rollback segment RB4

Moreover, do SQL*Loader command line format provide an option to specify database? In SQL*Loader GUI screen, it has provided database field for me to input.

Best Regards,
TK Tang
tk_tang_at_hotmail.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 26 1998 - 06:16:14 CDT