Re: Moving large amounts of data from one Oracle Server to another
Date: 2000/04/17
Message-ID: <38FB8900.605D7A95_at_prodigy.net>#1/1
Bob,
we went thru similar scenario and found out that it would be much faster
to move the data using "create table as select * from ..." and
specifying that the new table is unrecoverable. You'll have to define
the same tablespaces that you have on the master site. After everything
is created you can import all the constraints (without importing the
data). You can recreate indexes yourself or you can leave it to import.
Be careful with the default values - there will "get lost" during the
"create table as .." phase. This is Oracle's bug (they call it feature).
Let me know if you need more info.
BTW it took us less than an hour to move similar amount of data (running
several jobs at the same time).
Yuri
Received on Mon Apr 17 2000 - 00:00:00 CEST