Using Direct Path load in sqlldr

[williey]

Has anyone encounter issues with using direct path load in sqlldr with to_date function in the control card?

I have the following in my control card and all data are loaded except for the to_date conversion. When I disabled direct path load, the problem went away.

asofdt 		"to_date('09-JAN-2007')",
process_date 	"to_date('09-JAN-2007')"

Looking at the logs, I do see the following warning message.
Turning off the data_cache or increasing the size of the buffer did not fix the problem. So I assume it is not related to the data not loading problem.

Date conversion cache disabled due to overflow (default size: 1000)

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[oradba101]

Hi, williey

You can increase the command line date_cache parameter to a greater number.

Regards,


William Chadbourne
Oracle DBA

 

[williey]

Hi William,
I did that. Increased it from 1000 to 4000. But both asofdt and process_date columns are still empty. Unless I turn off direct path load.



------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[oradba101]

Hi, williey

How about setting it to 0?

Regards,

William Chadbourne
Oracle DBA

 

[williey]

I tried that too. Short of turning off direct path load, it will not load the last 2 columns using to_date functions.

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.