Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    6

    Unanswered: SQL command for turning off trigger and loging mode

    Hi,

    I have to load a 10000000-line file to a table which is with triggers, and the DB is with unbuffered loging.

    What shall I do to load the fat file as quick as possible?
    Is it possible to turn off trigger and loging mode in SQL language? How?
    I need the SQL command and execute it for a everyday job.

    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    There are some way, for example:
    Disabled trigger, set triggers for table disabled.
    Use utility dbload.
    Alter table to type raw, next insert, alter table to type standard and do back-up.
    Use utility onpload.

    Gustavo.

Posting Permissions

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