Transportable Tablespaces – Does it work between SE2 and EE?

Transportable Tablespaces - Does it work between SE2 and EE?I thought I had blogged about this topic already. But it seems to be that I stored this information somewhere else. Randomly I receive this question: Oracle Transportable Tablespaces – Does it work between SE2 and EE?

In addition often the question gets precised: Does it work in both directions or just one-way?

Transportable Tablespaces and Full Transportable Export/Import

Please find more information about these two very common Oracle database migration features:

And can you move between Standard Edition (SE, SE1, SE2) and Enterprise Edition (EE)?

Transportable Tablespaces – Does it work between SE2 and EE?

TTS does work between SE or SE2 and EE – but only in one direction. The Oracle License Guide contains the important information:

Transportable Tablespaces - Does it work between SE2 and EE?Transportable Tablespaces - Does it work between SE2 and EE?

Finally yes, you can transport tablespaces from Enterprise Edition (EE) into Standard Edition (SE and SE2) databases. But you can’t transport from SE or SE2 into an EE database as the transport packages to export the tablespace(s) aren’t present in SE and SE2.

 

Important clarification

The ability to use TTS and FTEX in the direction from EE to SE2 does not cover cross platform capabilities. The above wording has been precised for clarification to:

“Import of transportable tablespaces supported into SE2. Cross-platform backup and recovery for transportable tablespace-based migration is only supported with EE.

–Mike

PS: Thanks to Franck Pachot – I mixed the SE/EE in the last paragraph – the feature to export tablespace metadata is present in EE but not in SE/SE2. Therefore you can only UNPLUG from an EE database.

Share this: