By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
You say that when migrating Oracle from Windows to Solaris, you should precreate the database and tablespace on Solaris and use the imp utility to import all tablespaces from the Windows host. What about Endian format? They are different. You didn't mention this. Please advise.
It is true that the Endian-ness of Windows and Solaris platforms are different. But the Endian-ness only applies when using Transportable Tablespaces to copy data from one Oracle database to another. I was referring to traditional export/import methods, which create a platform-neutral dump file. The Endian-ness does not come into play here. If you do choose to use Transportable Tablespaces, which is a very valid option for moving data, then you will have to change the Endian format during the move. The Oracle Utilities Guide has further details.