Data Import Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Data Import Problem

  1. #1
    Join Date
    Mar 2001
    Posts
    5

    Red face

    I have ORACLE Ver. 7.3.

    I exported data by using "exp73.exe usename/password file=location" from dos.

    When I use "imp73.exe username/password file=location" to import data than messages come "Table already exists Skip table", "import terminated successfully."

    I need some help about import this database which replace older database in that user.
    Yogesh Bhardwaj

  2. #2
    Join Date
    Feb 2001
    Posts
    123
    Hi,

    I assume that you want to replace the old data?

    The best bet for this is to truncate the old versions of the tables into which you are importing, and add the 'ignore=y' flag to your import command. If you do not use truncate to remove the old data, then Oracle will import the new data, and attempt to add it to the existing data (you may either get duplicate rows, or errors because of trying to create duplicate rows - depending on uniqueness constraints and indexes).

    HTH

    David.

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