Migrating Oracle 10g from Windows 2003 to Unix

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database installation, upgrades and patches Oracle's Java database continues push into embedded database market How to use the Oracle Database Upgrade Assistant (DBUA) Oracle delivers database fixes in Critical Patch Update How to get the most out of Toad for Oracle 10 Coca-Cola Bottling swaps out Oracle for DB2 Oracle renews push into embedded open source software market Oracle releases new database, says 11g upgrade will cut costs Comparing servers for Oracle database 11g upgrades Choosing the right server hardware is all about choosing the right software The best of the Oracle 11g-ready servers Oracle database export, import and migration How to perform Oracle database recovery with a corrupt online redo log How to use the Oracle export utility to duplicate database structure How to perform an Oracle 8i to 10g migration Oracle upgrade process vs. Oracle exp/imp for 9i to 10g migration Coca-Cola Bottling swaps out Oracle for DB2 Oracle releases new database, says 11g upgrade will cut costs EnterpriseDB offers Oracle database users a 'bailout program' Oracle data export guide Solving common Oracle errors guide Oracle and SQL Server: BFF?

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary 10g  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

Because you are migrating to a different operating system, you cannot physically copy the database across to the UNIX server. There are, however, a few options available.

Export/import
Create an Oracle 10g database on your UNIX server, export your Oracle9i database, FTP the .dmp file over to the UNIX server and import it into your newly created database.

Create Table As Select (CTAS) via a Database Link
Create an Oracle 10g database on your UNIX server and create a database link from the database on the Windows server to the UNIX server database. Run 'create table as select …' statements to create your tables with the database on the UNIX server. Remember to also create any required indexes, constraints and referential integrity.

Use Oracle 10g Cross-platform Transportable Tablespaces
You can use the new cross-platform transportable tablespaces feature to move your database to your UNIX server. You must query the view V$TRANSPORTABLE_PLATFORM to see supported platforms and their endianness. Depending on the flavour of UNIX you plan to use, it can either be little or big endian. Windows is considered 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.

To be sure that the UNIX operating system you are planning to migrate your database to is supported and certified with Oracle 10g, you should also review Oracle's Certification Matrix.