Import text file over 3 GB with SQLLoader into table

[ping99]

Hi all,

Is it possible to load a text flat file over 3 GB with SQLLoader into an oracle table ?

I have tried with small flat file about 62 Kbytes which was worked fine but
when try to load with 3 gb file the same structure, never worked.

Please give some advice or ideas to result this problem.

TIA

 

[Turkbear]

Hi,
Some info please:

Oracle Version
Operating System


Also expand on the very vague never worked
What happend ( error message, explosion, termination of employment..)






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[LKBrwnDBA]

Yes it's possible, use the DIRECT=Y ROWS={nnnn} options.

Where {nnnn} is the number of rows per commit.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb