Problem Importing Data

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

[SURENKUMAR]

Hi,

when u are importing using imp73 username=username/password file=location u will get error if the objects that u are importing exists in the database so try to use this command

imp73 username=username/password file=location ignore=y

try this out

[saravana]

imp73 username=username/password file=location ignore=y

Ignore = y option ignores the create error messages and inserts all the rows into the existing tables..

But How can we import into existing tables and overwrite old rows with new rows which is in the dump file(import file).

Regards
Saravana