- 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.