Welcome Guest. Sign in or Signup

1 Answers

Interview » Technical » Data Mover » IGNORE_DUPS in Data Mover

IGNORE_DUPS in Data Mover

Asked by: 6073 views Data Mover

While importing, certain situations may warrant the use of IGNORE_DUPS. What does this command do? Explain a case where IGNORE_DUPS might be required. Finally, what impact does it have on the import speed and why?

Related Questions

1 Answers



  1. candidate on May 12, 2012 Reply

    When the IGNORE_DUPS is set, the Data Mover ignores duplicate-row error messages from the database. This way, the script does not error out.

    This might be useful when you want to import data into a table that already has some data.

    When this command is used, the DataMover cannot perform bulk inserts. This will drastically reduce the import speed.

    +4 Votes Thumb up 0 Votes Thumb down 0 Votes


Answer Question