Re: Moving an Instance

One possibility to speed export+import up would be to export to a named pipe in the original host, send the data over network to the target host to another named pipe, and import it from there. This way you can recreate the database with new, better parameters and do the export and import simultaneously. This will have the additional advantage of needing the least temporary space. And if you choose not to create indexes during the initial import it will be even faster, although they of course need then to be created later.

> Carlos A. Gonzalez wrote:
>
> > Dear Oracle Gurus;
> > I am in the process of moving an Oracle instance from one host to
> > another
> > I have identified the following ways to do such operation:
> > A) Export the whole database in the old host, create the database and
> > corresponding
> > tablespaces in the new host and then do the import.
> > Advantages: Optimize space usage (Compress parameter)
> > Disavantages: Too slow
 

-- 
! tapio.luukkanen_at_vtt.fi 
! työ (09) 456 6056, koti (09) 455 1067, käsi 040 5209 365