Re: Database import (two to one) question

li369_at_verizon.net (Jeff) wrote in
news:bd11d7fb.0408201348.5c28dd2a_at_posting.google.com:

> 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?

NO.
Yes, but with IGNORE=YES the import will not stop & continu to 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.
>

Yes.
It depends upon what your goal is & the contents of the two exports. Received on Fri Aug 20 2004 - 17:50:22 CDT