Problem running SQL*Loader utility
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