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

Thread: Data Import Problem

  1. #1
    Join Date
    Mar 2001

    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

    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).



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