Q

Large data migration from XML database to Oracle 10g

We are planning to migrate 3 TB of data from Oracle 9i XML DB to Oracle 10g. What do you recommend?

Hi Brian,
We are planning to migrate 3 TB of data from Oracle 9i XML database to Oracle 10g and I have suggested the Transportable Tablespace feature, but was told that we cannot because of a 9i XML database compatibility issue. What do you recommend?

One option is to transport the data to an Oracle 9i database that will support this move and then upgrade the database to 10g. This will normally be quicker than export/import for 3 TB of data. Also, you may wish to check to see if you have tables in a tablespace that are not using XML DB. Those tablespaces may be able to be transported with TTS. This can make for a shorter transition time for those tablespaces that do have XML DB...

components.

TTS does have its restrictions. If those restrictions apply to you, then the other alternatives are export/import, SQL*Plus COPY and homegrown solutions.

This was first published in August 2007

Dig deeper on Oracle database backup and recovery

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close