By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.