Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10g upgrade survey
Jaffar
I am willing to be corrected if i am wrong in saying this.
I am curious to know if the 9i database in this case contained only LMT tablespaces. If the 10g db is pre-created then the SYSTEM tablespace , i suppose, would be LMT; In such a case, it may not allow creating a DMT. Does it allow a DMT to be transported?
Thanks
Govindan
On Tue, 6 Mar 2007 09:47:19 +0300, "Syed Jaffar Hussain" <sjaffarhussain_at_gmail.com> said:
Williams,
You have missed another option of upgrade from 9i to 10g, i.e., transportable tablespaces. I know in 9i, it only works on the same OS.
If you are going to upgrade 9i database to 10g, transportable tablespace option also very handy. As 9i datafile are 10g compartible, it can be done with minimal downtime as well.
We have done with couple of database where it took very minimal downtime.
Of course, you need to see the possibilties and all the aspect before you choose any method.
We have also done in-place upgrade (manual upgrade).
Jaffar
--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA
[1]http://jaffardba.blogspot.com/
[2]http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
References
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 06 2007 - 02:34:22 CST
![]() |
![]() |