Re: Moving an Instance

One critical point is, are the hosts the same type of machine?

Also, are there any triggers, PL/SQL procedures, special grants, etc? Only the export method (among those you describe below) will keep these in sync.

Carlos A. Gonzalez <Carlos_A_gonzalez_at_us.dell.com> wrote in article <01bc5c7e$c65ab7c0$8a1ca68f_at_carlos.us.dell.com>...
> 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:
>
> 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
>
> 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 Sun May 11 1997 - 00:00:00 CDT