1. Join the 10i beta program 2. Convert your 9.2 datafiles using the cross-platform transportable tablespaces feature of a dummy 10i instance.
;-) Or... Back when one of our system swas at around 200M, we had a C program that dumped table data in parallel by rowid ranges, wrote the streams in SQL*Loader native format to named pipes that were being dd'd with large block sizes across a fast network, to several SQL*Loader processes on the other side using direct/unrecoverable. We ran several of these at a time. As soon as a table would finish we would kick off the index creation in parallel/unrecoverable mode. The goal was to get both the source and target hosts as close to 100% utilization as possible. This was Oracle 8.0.5, migrating Compaq Tru64 (DEC OSF to HP-UX 11 64-bit. The migration took 6 hours. It shouldn't have even taken that long, but we were clumsy in a few ways. There's a lot involved in a migration. Lots of dependencies and details to think about. I recommend repeated practice runs on test equipment before trying the real thing. There's a lot of blood to be squeezed out of this stone to get the time down and reliability up. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 9 Jun 2003, Goulet, Dick wrote: > Exp/imp of a 200GB database is possible, but I'd think the time required would be > the long pole in the tent. I'd say your looking at at least a 4 day weekend at best > and only if you used direct mode. Someone has hinted that you can simply move the > datafiles from one box to the other. Well I'd not loose the original system before > you prove that. My experience with database file from Solaris to HP-UX has been a > 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x). > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -----Original Message----- > Sent: Saturday, June 07, 2003 7:29 AM > To: Multiple recipients of list ORACLE-L > .. > > > Hi all: > > We are considering migration of an Oracle eBusiness Suite 11.5.8 from > HP-UX 11.0 to Solaris9. > > I'd like to know if anyone has done this and how daunting the task is. > > Are there any 3rd Party tools which can help out? > > Coming to the conventional approaches: > > 1. What do you think of Export/Import of a 200 GB database? > 1a. How much time will it take? > 1b. Any strategies for cutting that down? > > 2. How does CTAS over dblink compare to Export/Import? > > 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to > Oracle datafiles on Solaris 9. If so we would just need to recreate the > control files on the target database and we are done. > > Any suggestions, pointers, words of wisdom are greatly appreciated... > > Thanks & Regards, > Sashi > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sashidhar Kondareddy > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Goulet, Dick > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).