Re: Best option for moving database of server

From: Yechiel Adar <>
Date: Mon, 07 May 2012 07:23:40 +0300
Message-id: <>

In your case I will create a new DB with the same directory structure and name as the source and then choose:
1) Just copy the whole database files to the new location. 2) Use impdp with network link to copy the data.

Yechiel Adar

On 03/05/2012 11:25, Oliver wrote:
> Hi,
> I have to move a oracle database 10g ( to another server, what
> would you recommend me that is the best option for doing it? Cloning
> database?
> Architecture will be the same in the source and target server, different
> distribution of Linux, but with same architecture (x86-64).
> I had thought install oracle (I think that there isn't
> full install), I will have to install patchset and then cloning
> database :-?
> I know transport tablespaces too ... and export/import. What would be the
> best option? Database is not large/great, and it isn't a important
> database, it can be stopped, although I don't want a large downtime.
> Thanks beforehand.
> P.D.: If you prefer cloning database, some manual about it?
> Cheers...
> --

Received on Sun May 06 2012 - 23:23:40 CDT

Original text of this message