Re: Moving instance to another host

Carlos,

The CREATE AS won't work if you have LONG columns in a table. I believe the same holds true for LONG RAW and maybe even RAW. Don't remember where I read this and can't see to find the reference right now.

Joe

Carlos A. Gonzalez wrote:

    ...
    stuff deleted

> 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
 

-- 
Joseph M. Miklewicz  *** Please send e-mail replies to
jmjm_at_hogpa.att.com ***
AT&T
Crawfords Corner Rd.
Room 4K-208            908-949-3061
Holmdel NJ  07733-3030