Transportable tablespaces for Oracle on Linux upgrade
We want to migrate Oracle 9i on Red Hat Advanced Linux 2.1 to Oracle 10g R2 on Red Hat Enterprise Linux 4. Can I use transportable tablespaces to move my data to the new server that we are building?
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
- The compatible parameter must be set to at least 8.1 in both the source and target databases.
- You must be using Enterprise Edition to generate a transportable tablespace set (which you are).
- The source and target databases must have the same character set and national character set.
- The tablespaces you wish to transport must be self-contained tablespaces. Use the DBMS_TTS.TRANSPORT_SET_CHECK procedure to check whether this is true.
Dig Deeper on Oracle database installation, upgrades and patches
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments