|
|
|
|
|
|
|
|
|
|
| Re: Oracle migration from Windows to Linux [message #328053 is a reply to message #328052] |
Wed, 18 June 2008 13:21   |
j_satya
Messages: 5
Registered: June 2001
Location: India
|
Junior Member |
 
|
|
I am not familiar with Rman process and hence doing with export and import using data pump.
Following are the steps I am implementing and suggest if I need to execute any script to verify etc.
1. Complete export of the source database from Windows m/c using expdp
2. Creating the tablesspaces on target database i.e. on Linux
3. Import the data using impdp
But, while creating the tablespaces, after adding few datafiles by linux database is responding very slow. Any suggestions to improve the performance.
Thanks
Satya
[Updated on: Wed, 18 June 2008 13:24] Report message to a moderator |
|
|
|
|
|
| Re: Oracle migration from Windows to Linux [message #328061 is a reply to message #328046] |
Wed, 18 June 2008 14:05 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
in case this might apply....
From Note:119119.1
IMPORTANT:
* For the moment, do NOT use Expdp/Impdp when going to UTF8 or a other multibyte
characterset on ALL 10g versions including 10.1.0.5 and 10.2.0.3.
Also 11.1.0.6 is affected.
It will provoke data corruption unless you applied Patch 5874989!
This is caused by the impdp Bug 5874989.
The "old" exp/imp work fine. This problem is fixed in the upcoming
10.2.0.4 and 11.1.0.7 patch set.
All existing patches for this bug are found here:
http://updates.oracle.com/download/5874989.html
For 10.1.0.5, 10.2.0.2, 10.2.0.3 and 11.1.0.6 you can ask a backport
for Bug 5874989 if there is not yet a patch for your version/platform
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
