How to use imp to import data to existing tables using the EXPDAT.DMP file?
Posted on 2003-11-06
I used exp to export calldrb table on one database and expdat.dmp file is created. I copied the dmp file over to another server which has the same database setup as the one i did the export. I used imp to import the data to the database with existing calldrb table. The process failed because it prompted me the table has existed, aborting. Any idea how i can insert the data only into the existing calldrb table using imp? The calldrb table which i want to insert data into has no data in it. Please help me. Thank you!