Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    3

    Unanswered: trigger and sqlldr

    Hi
    I need to do a process before to do a sqlldr operation, i think it could be do it with a tigger which fire after insert, but i see that the trigger active after every row insert.
    Someone can help me and give a solution ¿how can i do to activate a process after a sqlldr operation? Is it possible??

    Thank you

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: trigger and sqlldr

    There's no "AFTER SQLLOAD" trigger or similar to help you, you will just have to process the data after it has been loaded. If the unprocessed data is invalid for the database, you may want to introduce a staging (temporary) table, i.e.
    1) Load data into staging table
    2) Process loaded data and insert into real table
    That way other users will not see the loaded data before you have processed it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •