OraFAQ Forum: Server Utilities » DAta migration from Oracle 9i to 10g

Home » RDBMS Server » Server Utilities » DAta migration from Oracle 9i to 10g (Oracle 9i on Linux as source and Oracle 10g Win as destination)

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

DAta migration from Oracle 9i to 10g [message #360754]

Sun, 23 November 2008 22:52

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

I have taken an export dump of oracle 9i which is running under Linux... I have installed oracle 10g in a windows machine.. I want to import the dump taken from 9i( on linux) to this 10g version under windows... How can I take this... Do I have to create any table space like the ones in 9i also in 10g or simple importing of the dump will be enough?? When I did the import activity through the 10g interface I got the import logerr which is attached for reference..

Attachment: IMPORT.LOG
(Size: 65.97KB, Downloaded 1429 times)

Report message to a moderator

Re: DAta migration from Oracle 9i to 10g [message #360794 is a reply to message #360754]

Mon, 24 November 2008 00:58

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

Senior Member
Account Moderator

As the OS Is not the same you have to precreate the tablespaces and import with "ignore=y".

Regards
Michel

Report message to a moderator

Re: DAta migration from Oracle 9i to 10g [message #360862 is a reply to message #360754]

Mon, 24 November 2008 02:56

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Tx for your comments..

Do I have to create the tablespaces of the same name or in different names???... If created in different names how to link the names with the ones in the dump... Will be very much thankful if you explain how to go about this...

Tx

Report message to a moderator

Re: DAta migration from Oracle 9i to 10g [message #360870 is a reply to message #360862]

Mon, 24 November 2008 03:39

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

Senior Member
Account Moderator

Same names.

Regards
Michel

Report message to a moderator

Previous Topic:	Incremental update.
Next Topic:	exporting partition tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 02:28:11 CST 2024