Migrating from 10g to 11g [message #556163] |
Thu, 31 May 2012 11:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
preet_kumar
Messages: 204 Registered: March 2007
|
Senior Member |
|
|
For migrating the database version 10.2.0.3 on Windows to version 11.2.0.3 on Linux i am using the transportable tablespace option.After the import of metadata and copy of tablespace datafiles to destination the sequences and functions are not available. Does it work if i later export and import the sequences and functions separately ?
Please need some advice
Thanks
|
|
|
Re: Migrating from 10g to 11g [message #556164 is a reply to message #556163] |
Thu, 31 May 2012 11:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>Does it work if i later export and import the sequences and functions separately ?
Yes, for some definition of work.
Most folks actually do regression testing to arrive at a definitive answer.
|
|
|