OraFAQ Forum: Server Administration » Updating oracle9i Db with the Updation of Oracle10g DB

Home » RDBMS Server » Server Administration » Updating oracle9i Db with the Updation of Oracle10g DB (Oracle9i and Oracle10g, Windows)

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

Updating oracle9i Db with the Updation of Oracle10g DB [message #332551]

Tue, 08 July 2008 23:38

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

Dear All

I want to run a Db in Oracle 10 g and I also want another DB in oracle 9i to be updated with the updating of Oracle 10g Db.

I want to make it as the concept of Primary domain controller and Backup domain controller.

is it possible? if Yes then How?

I have tried to create new DB in Oracle9i while pasting the data and control and password files of Oracle10g Db but an error occurred. Ora-00227 and Ora-00202

can any one Help me in this regard????

regards.

Report message to a moderator

Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332553 is a reply to message #332551]

Tue, 08 July 2008 23:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I also want another DB in oracle 9i to be updated with the updating of Oracle 10g Db.

Why is use of obsolete version V9 a requirement & to what benefit over using V10?

[Updated on: Tue, 08 July 2008 23:42] by Moderator

Report message to a moderator

Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332554 is a reply to message #332551]

Tue, 08 July 2008 23:45

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is not possible and quite non-sense.
It you want a backup, use the same version.
And Data Guard is made for this.

Regards
Michel

Report message to a moderator

Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332557 is a reply to message #332554]

Tue, 08 July 2008 23:50

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

Dear Sir

You are right. it is really non-sense.

Possibly I could not convey my point. the actual scenerio is :

Currently we are running Oracle9i.
Now we want to shift on Oracle10g.
.dmp of 9i can be imported in 10g but .dmp of 10g can not be imported in 9i.

If 10g becomes smooth, we will leave 9i. But in case of any error..... we will get back to 9i. so meanwhile i want it to be updated in order to avoid data loss.

I think i have conveyed my point.

still need help.

take care.

regards.

Report message to a moderator

Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332561 is a reply to message #332557]

Wed, 09 July 2008 00:21

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

... but .dmp of 10g can not be imported in 9i.

Not if you perform export of your 10g database using the 10g Export utility.
Therefore, export 10g using 9i's Export and import it into 9i using 9i's Import utility.

Report message to a moderator

Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332567 is a reply to message #332561]

Wed, 09 July 2008 00:45

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

Littlefoot wrote on Wed, 09 July 2008 00:21

Quote:

... but .dmp of 10g can not be imported in 9i.

Not if you perform export of your 10g database using the 10g Export utility.
Therefore, export 10g using 9i's Export and import it into 9i using 9i's Import utility.

Dear Sir,

I am using a lot of users for one Db. while exporting dmp, users are not fetched. grants are not fetched.

how to export entire db, so that i should not create users(synonyms) again.?

Regards.

Report message to a moderator

Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332578 is a reply to message #332567]

Wed, 09 July 2008 01:10

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

while exporting dmp, users are not fetched. grants are not fetched.

If you use "full=y grants=y" they are.

Regards
Michel

Report message to a moderator

Previous Topic:	oracle storage structure parameters
Next Topic:	How to enable/On recyclebin in 10g db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 21:53:22 CST 2024