Fred, There are a two different issues here .. 1. You seem to be on OPS currently ? Will you be "migrating" to OPS or non-OPS ? 2. You are moving from SGI to Sun.
As it is a change of platform, the ONLY "migration" option you have is Export-Create_new_Database-Import. The new Database can be either OPS or non-OPS -- that does not matter. You must create the same Tablespace Names before you Import -- else the import will try to create the tablespaces with the datafile names as in the original (source) database. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Fred Collington <[EMAIL PROTECTED]> 12/02/2002 11:28 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Oracle Migration Utility Can anyone advise me on using the migration utility? We are finally moving from 7.3.4 to 8.1.7. Has the utility worked well for you? Known bugs? Any info greatly appreciated. THe history, if you want to know. We have been stuck at 7.3.4 due to a lack of migration path for OPS on SGI equipment. We are now installing a Sun 4800, and will be ready to start testing the migration in March. Cheers, Fred ===== Fred Collington Oracle DBA Naval Air Warfare Center, Training Systems Division __________________________________________________ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Collington INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).