-
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
Suvashish
-
Have you given a thought to DIRECT MODE LOAD? 2GB is pretty big, direct load can save you a lot of time and resources.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
SQl*Load
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.
Suvashish
-
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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
Suvashish
-
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|