Re: Help with Large Transfer between DBs

From: <doid_at_my-deja.com>
Date: Tue, 30 Jan 2001 17:58:40 GMT
Message-ID: <956vc9$e88$1@nnrp1.deja.com>

As part of our Y2K work, we had to move a 500Gb database to a new server.

We chose to use a fast-unload utility provided by BMC software, then ftp, then direct-path load via sqlldr.

It's been two years, and I've forgotten many of the details, but it was certainly the best solution available at the time.

A similar product was available from Platinum.

I think Oracle8 introduced direct-path exports. I don't think direct-path imports are available yet, though.

hope this helps

>
> Tom Newton wrote:
> >
> > Does anyone know the best way to efficiently transfer a large number
of rows
> > (up to 1million rows) intra-day from several tables in one Oracle 8
database
> > to another?

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 30 2001 - 11:58:40 CST