My thoughts on below: 1) This will not be supported by Oracle Support since you are changing hardware/os. 2) Not sure if the datafile formats are compatible between sun and hpux. Ron Thomas Hypercom, Inc rthomas@xxxxxxxxxxxx "To really screw up Linux you have to work at it...To really screw up Windows, you have to work ON it..." Stephen.Lee@xxxxxxxx Sent by: oracle-l-bounce@xxxxxxxxxxx To rg oracle-l@xxxxxxxxxxxxx cc 05/25/2004 01:31 PM Subject RE: Moving a 250gig database from SUN to HPUX Please respond to oracle-l@xxxxxxxxxxxxx > -----Original Message---- > Your ideas/comments are appreciated. alter tablespace xyz begin backup; copy the files. alter tablespace xyz end backup; Rinse and repeat as needed. alter system archive log current; copy the logs and control files. recover and open the database on HPUX. There might a detail or two I left out because I haven't done it in a while, and I forget things. Like I forgot Angel's last line in the finale. Something like: "I want that dragon." But I probably don't have it just right, and it irritates me, because the more I think about it, the more I think it was a good last line. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------