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

Thread: sql loader question

  1. #1
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86
    it has been a while so apologies for being rusty...say i want to load some data into a table via sql loader, however if later on i want to add more data (say another record that has a primary key that is already in the table), would sql loader just write to the error log and stop or would it continue to load the data and omit the duplicate key.

  2. #2
    Join Date
    Feb 2001
    Posts
    20
    all the records wich are in violation will be discarded and put in .bad file

  3. #3
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86
    will the remaining data from the file be loaded or will it stop at that record and not load any more data? also, is this a normal task or bad practice? i.e. should more checks be done before sqlldr is even called? thanks for the reply.

  4. #4
    Join Date
    Aug 2000
    Posts
    462
    You can specify the number of errors to ignore:

    ERRORS=100000000

    The default is 50

    Until that number of errors is encountered, processing will continue, with good records loaded, and bad into *.bad file.

    Oracle DBA and Developer

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