Enhanced purging of the Oracle recyclebin

Introduction In the Oracle RDBMS v10, the ‘recyclebin’ for segments was introduced. If the recyelebin=on parameter is set, and a table is dropped, it is not actually dropped – it is renamed to a system-generated name. This can really help in situations where a table is accidentally dropped, as it can be easily recovered. However, […]

Oracle 12c Multitenancy

As you probably already know, Oracle 12c (the latest version of the database) has a Multitenant feature available as an additional Enterprise Edition cost option. This allows one “container” database to run multiple “pluggable” databases.   Pluggable and Container Databases I’ll be referencing the terms “PDB” and “CDB” a lot in the article, so it’s probably […]