SQLLDR + LINUX

From: John Goodens <wootang_warrior_at_hotmail.com>
Date: Tue, 19 Oct 1999 00:21:10 +0200
Message-ID: <7ug6hi$1t88$1@nntp01.global.co.za>

I CONSTANTLY have problems with sqlldr on a 4 million+ line file on Linux, the Memory usage goes
through the roof (378 Megs)
and the machine freezes.
Firstly I truncate the temporary table, then fill it using sqlldr with "replace into table_name" within the .ctl file

I've done a perl script that makes 10000 line files and then seperately loads them in, sqlldr behaves then.

Any Ideas? Received on Mon Oct 18 1999 - 17:21:10 CDT