Re: newbie : how move a database from a machine to another ?

Search deja.news for several threads about this. If you're moving on the same platform, it is very easy.

Essentially you need to:
Shutdown db, copy all db files (control, data, password, initxxx.ora etc) to new location. Create a new instance using oradim73. Startup nomount, rename the database files, shutdown, startup. Backup once all is up and running.

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Grégoire Jouen <gjouen_at_club-internet.fr> wrote in message news:38838121.AF78B11B_at_club-internet.fr...
> Hi
> I'm a new Oracle adm.. I have to move several instances from a old
> server to a new one
> (context : Orace 7.3.4 under Windows NT)
>
> Should I use import/export features, or anything else ??
>
> Thanks for ideas
>
> Greg
>
>
Received on Mon Jan 17 2000 - 15:18:13 CST