Problem running SQL*Loader utility

[dsuva]

Hi,

I need to load data into a table. The flat file containing the data is around 2GB in size. When i am running the SQL*Loader utility on this flat file, the process and database seems to be going into a hang.

Do i need to make any changes to my control file below.

------------------------------------------------------------
LOAD DATA
INFILE 'ORDERHDR_ALL.txt'
INTO TABLE ORDERHDR_ALL
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\''
TRAILING NULLCOLS
(

OHXACT,
OHSTATUS,
OHSTATUSFLG,
OHENTDATE,
OHREFNUM,
OHTSHDATE,
OHSLS,
CUSTOMER_ID,
OHCSEQ,
OHSNAME,
OHSADDR1,
OHSADDR2,
OHSADDR3,
OHSCITY,
OHSST,
OHSZIP,
OHSCOUNTRY
)
----------------------------------------------------------------

Thanks

[SANJAY_G]

Have you given a thought to DIRECT MODE LOAD? 2GB is pretty big, direct load can save you a lot of time and resources.

[dsuva]

Yes. Below is the command i am executing.

$sqlldr userid=sysadm control=ORDERHDR_ALL.ctl log=ORDERHDR_ALL.log bad=ORDERHDR_ALL.bad direct=true



Thanks.

[abhaysk]

Possibly you can think of spliting file into 4 different files & can use Parallel Direct Loads.

And also, if ur DB in archivelog mode, you could bypass by using UNRECOVERABLE clause in control file.

[dsuva]

How do i run the SQl*Loader in both parallel and direct mode at the same time.

I found that Parallel=TRUE & Direct=TRUE together in the sqlldr statement doesn't work

Thanks

[abhaysk]

http://technet.oracle.com/doc/server.../ch08.htm#1665