Hemant - You didn't mention performance issues. Is your database small enough and your downtime window large enough that performance isn't a big issue? That is nice when it happens. Also, I assume that you will do this entire process as a test first, and let your users check it out for anything missing.
Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, December 11, 2002 8:54 PM To: Multiple recipients of list ORACLE-L We are considering migrating some Oracle Databases across platforms -- from Solaris to HPUX. We'll, of course, be using Export-Import. I've been asked to come up with a list of issues / cautions to consider. e.g. I can think of Pre-Requisites : 1. The right [same or higher] version of the Oracle RDBMS + Patchset Release must be installed. 2. The database should be created with a minimum block-size of 4K, preferably 8K. 3. The database character-set should preferably be the same or a higher character-set. [eg US7ASCII or WE8ISO8859P1 or UTF8] 4. The NLS_LANG settings during the Export and Import must be complaint. Potential Issues : 1. BFILE references will become invalid as BFILEs are stored outside the database. 2. If there are tables containing LOBs, the import can be slower. [There was an 8i bug requiring COMMIT=Y to improve Import performance but commiting at every record, instead of at every buffer-size]. Recommendations / experiences appreciated. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale 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.com -- Author: DENNIS WILLIAMS 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).