Hi,

9i / win2k

Case 1 : - WORKS FINE.

Trying to load spaces into NOT NULL columns via conventionaly method using SQLLDR

the control file has ...
col1 char "NVL(:COL1,' ')"

Where col1 is the NOTNULL table column.


Case 2: - NO Luck - need ur advise.

Same as above just change is am trying thru DIRECT Method.


I understand, the direct method bypasses the sqlengine, but is there any alternative to achive the above using direct method.
I have to use direct method to cutdown the time.

Plz suggest.

Thanx
Jr.