DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Data overwrite

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all,

    I have been trying to do a full import into a database. But all the rows get appended to the table instead of overwriting it. Does anyone have any idea why is this so?

    Thanks,
    Shiva.

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    Imp does not perform UPDATES, only INSERTS.

    If you only want to see the new data and none of the
    old data, trucate your tables first.

    -John

  3. #3
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    Thanks John.

Posting Permissions

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


Click Here to Expand Forum to Full Width