#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Location
    Detroit, MI
    Posts
    1
    Rep Power
    0

    SQL Loader commit issue


    Hi,

    I have a requirement to load data with SQL Loader.
    The files may have data bout 1000 rows in it.
    The problem is I should not commit any of the rows loaded to the database until all rows in the file are processed.
    The commit should be done only if there are no errors.

    Is this possible with SQL loader ?? If yes how to do it.

    Thanks
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    68
    Rep Power
    11
    Srivic,

    I would use SQL*Loader to load the data to a staging table and then apply the logic on this table and move the rows as needed.

    Cheers,
    Dan

IMN logo majestic logo threadwatch logo seochat tools logo