This content has been marked as final. Show 6 replies
Yes the steps are correct
You can also use RMAN database transportable features which is much faster than usinf expdp and impdp. Since your source platform is windows and target platform is Linux and I think it is supported by RMAN because for database transpotable features source and target endian format need to be same. Please check your source and target endian format if both are same I would suggest you to go for Database Transpotation.
Hi may be your approach will very slow. you can also update by in 2 steps
1. Oracle database conversion from oracle 10g (window) to Oracle 10g (Linux)
2. UPDATE 10G TO 11G on linux
Note: Direct conversion method is not possible though Window oracle 10g to Linux Oracle 11g.
if you followed the above approach then your version should be atleast 10.2.0.4 and should be same on both side machines. Experts correct me if i am wrong....
Edited by: SANCHIT GUPTA on May 7, 2013 11:16 PM
Edited by: SANCHIT GUPTA on May 7, 2013 11:20 PM
Thank you for answering my question. I had one more regarding ENDIAN_FORMAT, basically is this a factor (i.e. Little ver. Big)?
Dump files created by export/import utilities are not affected by the endianness of the hardware or OS versions.
Great! thanks for the help.