OraFAQ Forum: Server Administration » Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp

Home » RDBMS Server » Server Administration » Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp (SUN SOLARIS 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Upgrade from 9.2.0.7 to 10.2.0.3 using exp/imp [message #322087]

Thu, 22 May 2008 08:17

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

Report message to a moderator

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

Michel Cadot
Messages: 68676
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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68676
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

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

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

Report message to a moderator

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

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

maoro
Messages: 312
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

Report message to a moderator

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

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Good to have your support.

Regards
Michel

Report message to a moderator

Previous Topic:	oem10g
Next Topic:	Mirroring An Oracle Schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 17:38:42 CDT 2024