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 (10.2.0.5.0) 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 10.2.0.1 (I think that there isn't 10.2.0.5 > full install), I will have to install 10.2.0.5 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... > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l