Originally posted by patel_dil
Yes you can import data into existing tables. Set IGNORE=Y in imp command.
If table has any rows and PK / UK CONSTRAINS
IGNORE=Y will work more slower than IGNORE=N
because oracle have to check each importing row aginst PK/UK constraint.
then if in import file we have any constraint violation oracle
have to log this row to imprt protocol (extrimly slow operation).

In my mind this isn't good recomendation.

may be truncate all tables before import can help, but i
didn't test that method newer.