Re: moving oracle database 9 from another computer to another one

On Dec 19, 12:13 pm, noumian <n.nou..._at_gmail.com> wrote:
> is it the right way to do it?
>
> stop me if i make a mistake
> - from the old pc ,i run : exp userid=system/manager file=c:\backup
> \export_full.dump
> log=c:\control\export_full.log full=y
> - then i go to the new pc, i install the oracle server without a
> database
> -then i open a comand line and i run :C:\> imp userid=system/manager
> file=c:\backup\export_full.dump
> log=c:\control\export_full.log full=y
>
> do i forget something?

Much. You need a database to import INTO to do what you've tried to explain. You really need to get a qualified Oracle DBA to do this for you as this may be a fairly involved task. If the operating systems are the same for both machines then the database can be cloned; if not then after the Oracle software installation a new database needs to be created and the export file from the source database can be imported into the new database on the other server.

I'll say this again:

You need a qualified Oracle DBA to perform this operation.

I would contract one immediately to get this task started.

David Fitzjarrell Received on Wed Dec 19 2007 - 12:49:17 CST