Home » RDBMS Server » Server Utilities » DAta migration from Oracle 9i to 10g (Oracle 9i on Linux as source and Oracle 10g Win as destination)
DAta migration from Oracle 9i to 10g [message #360754] Sun, 23 November 2008 22:52 Go to next message
mm_kanish05
Messages: 487
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 248 times)
Re: DAta migration from Oracle 9i to 10g [message #360794 is a reply to message #360754] Mon, 24 November 2008 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As the OS Is not the same you have to precreate the tablespaces and import with "ignore=y".

Regards
Michel
Re: DAta migration from Oracle 9i to 10g [message #360862 is a reply to message #360754] Mon, 24 November 2008 02:56 Go to previous messageGo to next message
mm_kanish05
Messages: 487
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
Re: DAta migration from Oracle 9i to 10g [message #360870 is a reply to message #360862] Mon, 24 November 2008 03:39 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same names.

Regards
Michel
Previous Topic: Incremental update.
Next Topic: exporting partition tables
Goto Forum:
  


Current Time: Thu Dec 08 04:03:46 CST 2016

Total time taken to generate the page: 0.13499 seconds