Re: migrating database between servers...

I don't know about the schema and things, but I know that I use import/export from an Oracle 6.0.3 database on one version of Unix (generally Pentium 90, 32MB RAM) to Oracle 8.1.5 database under Linux on RAID 5, etc. The import file doesn't have anything regarding the database location (although it might require the same SID, never tried changing that.)

You can also setup a network connection between the two boxes and create and copy individual tables via networking. (If doing an entire large database, I definitely recommend import/export, though.)

Terry Steyaert
steyaert_at_my-deja.com

In article <38A3147E.DB9F30A3_at_biostat.ufl.edu>,   Derrius Marlin <dmarlin_at_biostat.ufl.edu> wrote:
>
> We currently have an Oracle 7.3.4 production database (db
> backend to a web app) running under NT4 on one server but
> need to migrate it to a new NT4 server (better, faster
> hardware) that's just been setup.
>
> I don't want to simply clone the database from one machine
> to another because I'd like to change a few things about how
> the database is setup such as, rename the datafiles, store
> the datafiles on a RAID 5 partition but store the redo logs
> and indexes elsewhere. I'd also want to separate out just
> the tables associated with one specific schema instead of
> moving over the other objects associated with some other
> schemas being hosted by that production machine.
>
> What's the best way to migrate the DB from one machine to
> the other but still allow the flexibility of redefining the
> storage of some of the schema objects?
>
> Thanks,
> --
> -Derrius
>
> ----------- --------------
> Derrius Marlin, Systems Manager University of Florida
> dmarlin_at_biostat.ufl.edu Division of Biostatistics
> http://www.biostat.ufl.edu/~dmarlin (352) 392-8446
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 11 2000 - 08:54:04 CST