Data Import Problem

[yogeshbhardwaj]

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.

[Dave_A]

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.