Re: 10g upgrade survey

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Tue, 6 Mar 2007 08:34:22 UT
Message-Id: <1173170062.30884.1177943723@webmail.messagingengine.com>

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.

1. Install 10g on the target, create db with all the users
2. On source, bring all the tablespace to read only mode.
3. Export with transportable tablespaces.
4. move all the datafiles from source to target (this is only the time consuming process)
5. Import at target.

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

---

"Winners don't do different things. They do things differently."

References

1. http://jaffardba.blogspot.com/
2. http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 06 2007 - 02:34:22 CST