I have completed several medium and large "Cross Platform Oracle migrations" [using EXP/IMP for most of it...and some other creative movement methods} Unfortunately the devil is in the details. Potential pains; - 24X7 db / app - grants by sys - use of advanced datatype (XML, TIMESTAMP, LOB cause problems/slowness) - enabling constraints - snapshots and or replication issues - invalid objects - and any number of potential bugs (just had one where Oracle failed to create private synonyms for objects over db links) Any when you realize this it is better to break up the EXP/IMP for speed the will only further require a detailed plan or something is bound to be left behind or undone. hth Chris Marquez Oracle DBA -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fred Smith Sent: Tuesday, August 16, 2005 12:53 PM To: oracle-l@xxxxxxxxxxxxx Subject: Cross-platform database move Hello, I am attempting to make a copy of a production database that is on HP-UX and put it on a Solaris 5.8 box for testing. What are my choices for copying from one platform to the other? Just exp/imp? Both databases are 9.2.0.x. I'm dealing with roughly 90Gig. tia, -Fred S. _________________________________________________________________ Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l