Moving an Instance

Dear Oracle Gurus;

I need some help

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:

1. 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    

B) FTP the data files to the new host, copy the data files to the corresponding

   directories, edit the Control File and startup the instance.

   Advantages: Faster to do
   Disavantages: No way to optimize the old database.

Our resident ORACLE Guru insists in doing it the following way, which I am kind of resisting
beacuse besides the fact you have to identify every user/table, triggers and stored procedures
will require special handling plus the fact that you may overlook some special tables, views,
what not....

Please comments on approach C) will be appreciated.         

C) Create a Database in the new host, establish a link to the old instance.

   and copy all the tables using something like:

   CREATE DATABASE LINK dblink
   CONNECT TO user IDENTIFIED BY password USING 'connect_string';         

   CREATE TABLE new_table
   TABLESPACE tablespace
   AS SELECT * FROM old_table_at_dblink

   Advantages: Please comment
   Disavantages: Please comment Received on Fri May 09 1997 - 00:00:00 CDT