Database import (two to one) question

Hi,

I have some questions regarding the oracle export and import. We currently have two different database servers on different machines. Oracle 8.1.7 is on our Windows 2000, and oracle 8.0.5 is no NT.

Now, we've bought oracle 10g and installed on another machine, Windows 2003. We want to move all the data from the above two databases into the new one and combine them to one. I want to do the full export from those two databases respectively and then import them to the new one. Here are my questions:

1. Before I do the import, do I need create tablespaces and data files in the new database? If I've already created, will I get errors when I doing the import?
2. Because I have two export files, can I do two full imports? Does it cause any confliction? In those two database, I have some tables with the same name.

Very much appreciate for any help.

Jeff Received on Fri Aug 20 2004 - 16:48:51 CDT