RE: Migration utility from 7.3.4 to 9i ??
Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
Re:RE: Migration utility from 7.3.4 to 9i ??
Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major change that you can't bypass. Dick Goulet Reply Separator Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 2/7/2002 6:05 AM Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
RE: RE: Migration utility from 7.3.4 to 9i ??
Hi Dick, According to the 9i Migration Utility Guide, the Mig Utility that comes with 9i will migrate 7.3.x database to 9i directly. Unfortunately we had no 7.3.4 database to migrate to 9.0.1. So I have not had a chance to test it myself. We migrated several 7.3.x database to 8.x using Mig Util without any problems. Of course, one can always use export/import for such things. - Kirti -Original Message- Sent: Thursday, February 07, 2002 8:22 AM To: Deshpande; Kirti; Multiple recipients of list ORACLE-L Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major change that you can't bypass. Dick Goulet Reply Separator Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 2/7/2002 6:05 AM Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
Re:RE: Migration utility from 7.3.4 to 9i ??
Dick, Even if you take export/import route it should be fine. As far as the rowid is concerned it should be the same as rowid in version 8. so logically there will be a conversion of the row-ids from older format(v 7.3.4) to the new format( v 8 or v 9), and nothing is needed to be done explicitly, whenever a table is being accessed by the user for the first time after the migration, row-ids will be converted to ne format implicitly. I have not migrated to 9 from 7.3.4. Still on 8.1.7. Shaibal From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re:RE: Migration utility from 7.3.4 to 9i ?? Date: Thu, 07 Feb 2002 06:23:42 -0800 Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major change that you can't bypass. Dick Goulet Reply Separator Author: "Deshpande; Kirti" <[EMAIL PROTECTED]> Date: 2/7/2002 6:05 AM Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). MSN Photos is the easiest way to share and print your photos: Click Here -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder 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).
Re:RE: Migration utility from 7.3.4 to 9i ??
Shaibal, whenever a table is being accessed by the user for the first time after the migration, row-ids will be converted to ne format implicitly. To avoid this situation, just after migration from 7.3.4 to 8i, we normally export full database to a null device so that this issue may be avoided during application usage... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 07 Feb 2002 13:06:47 -0800 MOHAMMAD RAFIQ _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx ---BeginMessage--- Dick, Even if you take export/import route it should be fine. As far as the rowid is concerned it should be the same as rowid in version 8. so logically there will be a conversion of the row-ids from older format(v 7.3.4) to the new format( v 8 or v 9), and nothing is needed to be done explicitly, whenever a table is being accessed by the user for the first time after the migration, row-ids will be converted to ne format implicitly. I have not migrated to 9 from 7.3.4. Still on 8.1.7. Shaibal From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re:RE: Migration utility from 7.3.4 to 9i ?? Date: Thu, 07 Feb 2002 06:23:42 -0800 Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major change that you can't bypass. Dick Goulet Reply Separator Author: "Deshpande; Kirti" <[EMAIL PROTECTED]> Date: 2/7/2002 6:05 AM Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). MSN Photos is the easiest way to share and print your photos: Click Here -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder 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). ---End Message---
Migration utility from 7.3.4 to 9i ??
Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer 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).