Im'm trying to export and import table data using the Oracle Export and import utility. I was able to do this successfully for the same company. I need help in importing data across different company using the Oracle Import utility.

E.g Data from company 100 to comp 200 using the oracle Export/import utility. Is this possible??? If Yes, how??

I don't want to use the exchange schemes or any other dataloading mechanism.

Can anyone help me in this.

Hi,

Please be informed , Oracle Import utility shall restore data to the same company table names .
so you could accomplish the same by using Sequential dumps.

just give it a try.

Regards,
Sushil Kumar Mudaliar

You will also want to make sure that you use the Copy Company Data session to change the company number in the tables. tccom0214m000