Ask the Expert

Large data migration from XML database to Oracle 10g

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: