DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql*loader

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    sql*loader

    Hi,
    What is the difference between Bad file and Discarded file in
    sql*loader.....could somebody explain with one example...

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Discard File: This file contains the records filtered out by SQL*loader because they do not match the record-selection criteria (Specified in When clause) defined in the control file.

    Bad File: This file contains records rejected by Oracle or SQL*loader because either the records were in invalid input format or violate constraints or data-types.

    HTH
    Sanjay

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    BAD_FILE = is the records (upto the rejection limit) that are rejected during the load. i.e. they format of the record isn't matched by the format in the control file.

    DISCARD_FILE = is the records that did not satisfy the selection cirteria in the control file. Meaning the record is in violation off a condition specified in the control file as opposed to being illformed

    SANJAY_G types a bit quicker than me...
    OCP 8i, 9i DBA
    Brisbane Australia

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