- 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
Related Q&A from Maria Anderson
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk."continue reading
I'm getting errors while installing the Database Configuration Assistant.continue reading
Can I use /var/opt/oracle/oratab to specify listener information?continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.