Welcome Guest. Sign in or Signup

1 Answers

Interview » Technical » Data Mover » IMPORT vs REPLACE_ALL vs REPLACE_DATA

IMPORT vs REPLACE_ALL vs REPLACE_DATA

Asked by: 6438 views Data Mover

Once you have the data exported into the .DAT file from the source DB, you have many ways to push it into the target DB. IMPORT, REPLACE_ALL and REPLACE_DATA are available options that you can use. Can you compare between these commands?

Related Questions

1 Answers



  1. manoranjan4444 on Jul 30, 2013 Reply

    IMPROT : Irrespective of table existence in target, it imports data in target and if table is not present; it creates table, index and triggers. For transfer between two databases both must have identical records.

    REPLACE_ALL : Drops existing target table and creates new table and indices and imports.

    REPLACE_DATA : Drops existing target table data and creates replace with new data.

    +4 Votes Thumb up 0 Votes Thumb down 0 Votes


Answer Question