Re: move database to new server/directory

"Helmut Schneider" <jumper99_at_gmx.de> schreef in bericht news:4s2qmbFtf042U1_at_mid.individual.net...
> What's in a namespace (xml_at_ns.com) wrote:
>
>> "Helmut Schneider" <jumper99_at_gmx.de> schreef in bericht
>> news:4s2mntFtugu3U1_at_mid.individual.net...
>>> 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?
>>
>> Hire a DBA for one day?
>
> If I could afford I would not post here.
>
> --
> Please do not feed my mailbox, Swen still does his job well

OK! I feared this was a production situation. Export/Import should not depend on ORACLE_HOME settings, so that can't be te reason for the failure.
Which exact steps did you take to do the export/import? What do you mean by 'All the config?' (specially when the directories are different, the original uses separate directories for installation and data, the copy doesn't (yet))
How many database schemas are involved? How much data? Could a default installation and one user export/import do the job?

Shakespeare Received on Thu Nov 16 2006 - 04:21:17 CST