-
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.
-
1.why not disable the constraint.
2. Do not load any thing to this column. Set default space at the table level.
-
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.
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
|