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: Transportable Tablespases: Character Sets – Same same but different? (May 25, 2016) Transportable Tablespaces and Read-Only in Oracle 12c (Dec 2, 2016) Full Transportable Export/Import – Things to…

Can you simply switch from SE2 to EE with Oracle Multitenant

This question is coming up from time to time – and currently not covered in the official Oracle documentation as far as I know: “Can you simply switch from SE2 to EE with Oracle Multitenant?” Yes, you can! First of all, the switch is possible and tested. But you’ll have to satisfy a few requirements: Both database versions must be the same Both databases must have the same character set (in Oracle Database 12.1) That’s it. Simply unplug your Standard Edition 2 PDB and plug it into your Enterprise Edition CDB. In addition you may have to run several component…

Adaptive Execution Plans – not available in Oracle SE2

I received an interesting question on the blog the other day: “Are Adaptive Plans an Enterprise Edition only feature?” What does the License Guide say? The Oracle Database 12.2 License Guide says: What does www.oracle.com say? This is the link the customer came across – also saying that Adaptive Execution Plans are an Enterprise Edition only feature: What does this mean for SE2? That is the question Adam had. Does this impact SE2? Will I get an error or – even worse – a license violation if I have optimizer_adaptive_plans=TRUE – which is the default? No, none of it will…