Home » RDBMS Server » Server Administration » Upgrade 9i to 10g
Upgrade 9i to 10g [message #185826] Thu, 03 August 2006 15:19 Go to next message
kjm0001
Messages: 11
Registered: February 2006
Junior Member
I am planning to upgrade our WIN2K Oracle 9i to 10g rel 2. I have read the upgrade documentation for DBUA and Manual upgrades. Our WIN2K is upgraded to 2003. The SA is slicking the box down so we won't have our 9i on that box. We plan to install the 10g only. My question is can I just create a 10g Database then do a full import of my 9i database?..Is this considered a legitimate upgrade? I haven't seen any documentation on just doing export/import upgrades.

Report message to a moderator

Re: Upgrade 9i to 10g [message #185851 is a reply to message #185826] Thu, 03 August 2006 17:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Is this considered a legitimate upgrade?
Depends on the data and options you are using.
Are you using any of those database options? XML Schema/Spatial/Text etc?
Else ( and if the data is just plain data), export/import will work.
I would first setup a parallel 10g instance, test the application and then do the upgrade once for all.

Report message to a moderator

Re: Upgrade 9i to 10g [message #185982 is a reply to message #185851] Fri, 04 August 2006 11:21 Go to previous message
kjm0001
Messages: 11
Registered: February 2006
Junior Member
thanks for your input...I finally found the documentation I needed for the upgrade using export/import.

Report message to a moderator

Previous Topic: Auditing the Database
Next Topic: Help Designing a Billion rows System
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:35:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.