sqlldr->spaces->not columns???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sqlldr->spaces->not columns???

  1. #1
    Join Date
    Jan 2002
    Posts
    148
    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.


  2. #2
    Join Date
    Mar 2002
    Posts
    48
    1.why not disable the constraint.
    2. Do not load any thing to this column. Set default space at the table level.

  3. #3
    Join Date
    Jan 2002
    Posts
    148
    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
  •  


Click Here to Expand Forum to Full Width