Q

Migrating to a different Endian format

You say to precreate the database and tablespace on Solaris and use the imp utility to import all tablespaces from the Windows host. What about Endian format?

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.
This was first published in February 2007

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close