Migrating from Linux/Solaris to Windows and vice versa

I need to migrate from Oracle on Linux or Sun Solaris to Oracle on Windows 2000 and the other way around. What are the issues with the migration?

Maria Anderson

Published: 12 Oct 2005

I need to migrate from Oracle on Linux or Sun Solaris to Oracle on Windows 2000 and the other way around, i.e., from Oracle on Windows 2000 to Oracle on Linux or Sun Solaris. What are the issues with the migration?

It's not clear from your question whether your Oracle database(s) will remain at the same release level across platforms so I'm assuming that they will. It is also not apparent from your question whether we are dealing with Oracle9i and lower or Oracle 10g. If we're dealing with Oracle9i and below, the only option to migrate your database across platforms is to use the Oracle utilities export and import.

If your database is at Oracle 10g, you have another option, which is to use the cross-platform transportable tablespaces...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate Email Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

feature. Solaris, Linux and Windows are supported platforms (you can query the view V$TRANSPORTABLE_PLATFORM to see supported platforms) but they are of different endianness. Solaris is big endian while Linux and Windows are little endian, so there may be an additional step involved to convert the tablespaces being transported on either the source or target side.

To read more about the cross-platform transportable tablespace feature, download the Oracle Database Administrator's Guide 10g (release 10.2) from Oracle Technology Network, which can be found here.

March of the penguins: how we migrate from UNIX to Linux

How to perform a Big to Little Endian conversion in Oracle 8i

How to perform an Oracle 8i to 10g migration

How to use RMAN CONVERT to migrate from Solaris to Oracle 11g RHEL

Era Software raises $15.25M for enterprise data management

Dgraph GraphQL database users detail graph use cases

Pandemic triggered data security movement to DBaaS

Startup Veezoo emerges from stealth with NLQ-based platform

15 data science tools to consider using in 2021

Insightsoftware acquisition of Izenda targets embedded BI

S/4HANA Cloud SaaS ERP: Buying team overview

SAP forms financial services partnership with Dediq

Unpatched applications threaten SAP security

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Incorporate diversity and inclusion in technology design

Microsoft previews OpenJDK distro to the delight of devs

Supreme Court ruling on Java APIs eases developer worries

Nvidia SDK simulates quantum computing circuits on GPU systems

Programmable processor technology for next-gen data centers

Data processing units accelerate infrastructure performance

OpenText releases Cloud Editions content services updates

Adobe courts small businesses with Acrobat Pro package

Know when to use a headless CMS and when it's not worth it

Face mask detection a newcomer to employee surveillance

20 diversity and inclusion tools to power your DEI program

DEI tools arrive at critical time for HR