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

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

Leave a Reply

Your email address will not be published. Required fields are marked *