Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Migrating/upgrading from 7.3.3 to 8.0.5
We have a 4GB database that we are planning to migrate from 7.3.3 to 8.0.5.
At the same time there are a number of database structural changes that also
have to be implemented. As some of the tables contain several hundred
thousand rows I am trying to work out the quickest way to do this. I can
create new correctly sized 8.0.5 database for the new DB structure. To move
the data from the old database to the new database, will it be quicker to
use a dblink and just copy the rows (insert into... select ... or perhaps
using SQL+ copy) or would I be better off creating loader input files and
using the loader to do this?
Any thoughts appreciated
Ken White
Received on Tue Apr 27 1999 - 01:24:07 CDT