Re: move database to new server/directory

From: What's in a namespace <xml_at_ns.com>
Date: Thu, 16 Nov 2006 10:45:42 +0100
Message-ID: <455c334c$0$326$e4fe514c@news.xs4all.nl>

"Helmut Schneider" <jumper99_at_gmx.de> schreef in bericht news:4s2mntFtugu3U1_at_mid.individual.net...
> Hi,
>
> I'm totally new to oracle, only have a bit knowledge of MS- and mysql.
>
> I would like to move a database (and if possible all the config) to a new
> Windows server. I tried exp and imp, but probably it fails as the old
> server installation points to d:\oradata and d:\orahome_1 while my new
> standard installation of 10g points to d:\oracle\product\10.2.0. I'd like
> to keep that as it is obviously default.
>
> Can someone please point me what exactly I have to do now? Preferrable
> using OEM?
>
> Thanks, Helmut
>
> --
> Please do not feed my mailbox, Swen still does his job well

Hire a DBA for one day?

Shakespeare Received on Thu Nov 16 2006 - 03:45:42 CST