Hello,

Here is the situation. I have schema name aaa and schema name bbb. Both of them in same 8i database. But i need to do export/import at table level. Schema bbb has tabled called macadd and so does schema aaa has same tablename macadd. But i need to take an export of macadd( from schema bbb) to the already existing schema aaa.

But here is the twist. Schema aaa's table macadd already have data in it. So my question when i take an export from bbb. And import that into schema aaa table. Will it insert the data from the begin or just add to the exiting data.

Well i need to keep the data in schema aaa tables and just add the new data from schema bbb tables ??? any idea how ??? And the fact that We as DBA's in the company dont load data thru sqlldr. Which would have been a lot of help in this situation. So only way i been told is so do exp/imp. Thanks in Advance. Thanks