| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Migrating 8i to 9i
If you are talking about the Oracle features in 9i that aren't there in
8i then migrating in place won't make you "loose" any features.
I feel that the migrate in place is much easier and seamless then the export/import method that invariably involves additional tweaking.
As far as move data around you could do that as a separate process after the migrate in-place. I usually opt not to change too many things at once. =20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kline.Michael
Sent: Thursday, September 23, 2004 4:16 PM
To: oracle-l_at_freelists.org
Subject: Migrating 8i to 9i
If one migrates in place, and it's what one may call a "plain production
database", no "fancy" stuff, etc. from 8.1.7.4 to 9.2.x (as it may be
another month or two), are any options lost?
=20
These are 1-2 TB and we may be moving to another server and a SAN/fiber back plane environment.
=20
This may be a point where we could temporarily get new disks or simply move the disks from the one server to the other and then convert to 9i.
=20
I could do a lot more "neat stuff" if I could do export/import but at the size, I don't know if we would have the time. For instance, instead of 12-18 "disks" I may have 2-4 600GB "disks" as it were, etc.
=20
They are supposed to have a huge Hitachi SAN that auto balances the load and if it sees the load is on one tray and it's too heavy will eventually migrate some of the data to another tray without the knowledge of the Unix box. I don't get that heavy into the "guts" of them so not exactly sure how this happens.
=20
But other than that, if I don't export/import, do I "lose" any features. Tablespaces are almost all LOCAL and UNIFORM extents, usually 10 or 100 meg.
=20
Michael Kline
Database Administration
SunTrust Technology Center
1030 Wilmer Avenue
Richmond, Virginia 23227
Outside 804.261.9446
STNet 643.9446
Cell 804.744.1545
<mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com=20
************************************************=20The information transmitted is intended solely=20 for the individual or entity to which it is =20 addressed and may contain confidential and/or=20 privileged material. Any review, retransmission,=20 dissemination or other use of or taking action=20 in reliance upon this information by persons or=20 entities other than the intended recipient is=20 prohibited. If you have received this email in=20 error please contact the sender and delete the=20 material from any computer.=20
************************************************=20
-- http://www.freelists.org/webpage/oracle-l BEGIN-ANTISPAM-VOTING-LINKS ------------------------------------------------------ Teach CanIt if this mail (ID 10974823) is spam: Spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D10974823&m=3D6b95= 30f6b 199 Not spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D10974823&m=3D6b95= 30f6b 199 Forget vote: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D10974823&m=3D6b95= 30f6b 199 ------------------------------------------------------ END-ANTISPAM-VOTING-LINKS -- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 23 2004 - 15:27:54 CDT
 |
 |