sqlldr->spaces->not columns???

[Jr]

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.

[vanirame]

1.why not disable the constraint.
2. Do not load any thing to this column. Set default space at the table level.

[Jr]

Originally posted by vanirame
1.why not disable the constraint.

NULLABLE - Direct Path load inserts NULLs , obviously NVL is bypassed.

Originally posted by vanirame
2. Do not load any thing to this column. Set default space at the table level.

All values for that column being loaded are not just blanks, so i just cant ignore the column. And BTW setting Default at table level has no affect during Direct load.

Any thing else ....please suggest.

Thanx
Jr.