Home » RDBMS Server » Server Administration » Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp (SUN SOLARIS 10)
Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp [message #322087] Thu, 22 May 2008 08:17 Go to next message
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
Member
Good afternoon,

I've got to migrate a database from 9.2.0.7 to 10.2.0.3.

My database 10.2.0.3 is created and I've already created the tablespaces as it is on the 9.2.0.7 DB.

I've performed a full backup of the 9.2.0.7.

My question is: The full export also has the system ans sys schemas.

Are they going to get imported in the 10.2.0.3 DBs?

It's already created there so I have no idea how this is going to work and what I should expect.

Can someone confirm that I can simply perform a full import and it's going to simply work?

thanks

Nicolas
Re: Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp [message #322109 is a reply to message #322087] Thu, 22 May 2008 09:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Export never contains SYS schema.

But one question, why don't you use dbua to upgrade?

Regards
Michel
Re: Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp [message #322112 is a reply to message #322109] Thu, 22 May 2008 09:29 Go to previous messageGo to next message
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
Member
Hi.

Thanks for the answer.

I can't use DBUA because the project is major and I can't just do that...

We are currently qualifying needs, for Webmethod; It requires a migration to a new version as well, I already got a 10g database and I've been asked to provide this environment with the 9i DB data.

That's how I end up with an exp/imp to 10g.

I will just full import the whole DB then.

Thanks a lot for your help

Nico
Re: Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp [message #322114 is a reply to message #322112] Thu, 22 May 2008 09:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I can't use DBUA because the project is major and I can't just do that...

This is a non-sense, from my experience that is more likely to have problem with export/import than dbua but it is your choice.

And to answer your question:
Quote:
Can someone confirm that I can simply perform a full import and it's going to simply work?

Noone can confirm that, I can confirm that you will likely have problems.

Regards
Michel
Re: Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp [message #322129 is a reply to message #322087] Thu, 22 May 2008 10:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Can someone confirm that I can simply perform a full import and it's going to simply work?
I'll confirm with a 100% guarantee that a full import will work
& if there are problems you'll get a full refund that you paid for this guarantee.
Re: Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp [message #322303 is a reply to message #322129] Fri, 23 May 2008 01:12 Go to previous messageGo to next message
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
Member
I'll give you my bank account number x)

Thanks a lot for your 100% no fat warrantee Smile
Re: Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp [message #322305 is a reply to message #322087] Fri, 23 May 2008 01:21 Go to previous messageGo to next message
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
Member
Hi.

Quote:
This is a non-sense, from my experience that is more likely to have problem with export/import than dbua but it is your choice.


Seriously, if I could use the original database I would have done that and it would be over, but I can't... It's being used, the application on top is huge, lots of things have to be tested, mainly at application level and the database I've been handed over is already a 10g DB.

Concerning having problems, I don't mean problems at large, I was just worrying about system and sys tablespaces not a problem with data types, relations etc... Which to some extent, I'm expecting.

[Updated on: Fri, 23 May 2008 01:21]

Report message to a moderator

Re: Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp [message #322870 is a reply to message #322087] Mon, 26 May 2008 09:07 Go to previous messageGo to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
take a cold backup of your 9.2.0.7 database;
restore it on a test server
setup oracle 10g on the test server
user dbua
test your application
i guarantee problems with export import

cheers
Re: Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp [message #322881 is a reply to message #322870] Mon, 26 May 2008 10:20 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good to have your support.

Regards
Michel
Previous Topic: oem10g
Next Topic: Mirroring An Oracle Schema
Goto Forum:
  


Current Time: Thu Dec 08 21:52:39 CST 2016

Total time taken to generate the page: 0.10181 seconds