Home » RDBMS Server » Server Administration » Updating oracle9i Db with the Updation of Oracle10g DB (Oracle9i and Oracle10g, Windows)
icon2.gif  Updating oracle9i Db with the Updation of Oracle10g DB [message #332551] Tue, 08 July 2008 23:38 Go to next message
myclassic
Messages: 127
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.
Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332553 is a reply to message #332551] Tue, 08 July 2008 23:42 Go to previous messageGo to next message
BlackSwan
Messages: 25038
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332557 is a reply to message #332554] Tue, 08 July 2008 23:50 Go to previous messageGo to next message
myclassic
Messages: 127
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.
Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332561 is a reply to message #332557] Wed, 09 July 2008 00:21 Go to previous messageGo to next message
Littlefoot
Messages: 20895
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.
Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332567 is a reply to message #332561] Wed, 09 July 2008 00:45 Go to previous messageGo to next message
myclassic
Messages: 127
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.
Re: Updating oracle9i Db with the Updation of Oracle10g DB [message #332578 is a reply to message #332567] Wed, 09 July 2008 01:10 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: oracle storage structure parameters
Next Topic: How to enable/On recyclebin in 10g db
Goto Forum:
  


Current Time: Mon Dec 05 14:53:38 CST 2016

Total time taken to generate the page: 0.20436 seconds