Q
Problem solve Get help with specific problems with your technologies, process and projects.

Migrating 9i database on Windows to 10g on SLES

I have a 200 GB database running on Oracle9i release 2 on a Windows 2003 platform. We want to migrate the database on SLES 9 server Oracle10g rel2. Please guide me on the steps involved in doing this.

I have a 200 GB database running on Oracle9i release 2 on a Windows 2003 platform. We want to migrate the database on SLES 9 server Oracle10g rel2. Please guide me on the steps involved in doing this.
You basically have three choices for migrating your database. Because you are also changing platforms, you are somewhat limited in how you can upgrade your database.

Export/import

Create an Oracle 10g database on your Linux server, export your Oracle9i database, FTP the .dmp file over to the Linux 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 Linux server and create a database link from the Oracle 10g database to the Oracle9i database. Run 'create table as select …' statements to create your tables with the data in the Oracle 10g database. Remember to also create any required indexes, constraints and referential integrity.

Use Oracle 10g cross-platform transportable tablespaces

Because your source server is Windows 2003, you can install Oracle 10gR2 on your Windows server, upgrade your database in place and then use the new cross-platform transportable tablespaces feature to move your database to your Linux server. Both Windows and Linux are supported platforms (you can query the view V$TRANSPORTABLE_PLATFORM to see supported platforms) and they are of the same endianness (little endian) so there is no need to convert the tablespaces being transported.

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.

You should also review the Oracle Database 10g Release 2 (10.2) Upgrade Guide.

This was last published in December 2006

Dig Deeper on Oracle database export, import and migration

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close