Database Multilingual Engine (MLE) hands-on Posted on September 30, 2023 , Modified on January 12, 2026 , by Yannick JaquierTable of contents Preamble Multilingual Engine (MLE) testing Multilingual Engine (MLE) advanced testing References Read more Oracle SQL Leave a comment
Multitenant pluggable database cloning and moving – part 2 Posted on September 10, 2023 , Modified on October 24, 2023 , by Yannick JaquierTable of contents Preamble Pluggable database cloning Cloning local Cloning remote Refreshable clone PDB Proxy PDB Moving pluggable database across containers Unplug/plug a PDB Relocating a PDB References Read more Oracle Multitenant Leave a comment
Multitenant pluggable database upgrade – part 1 Posted on August 21, 2023 , Modified on August 7, 2023 , by Yannick JaquierTable of contents Preamble Pluggable database upgrade from 19c (19.15) to 21c (21.6) Creating a split mirror clone pluggable database Cloning a pluggable database from a pluggable snapshot References Read more Oracle Multitenant 1 comment
Database Security Assessment Tool (DBSAT) hands-on Posted on July 31, 2023 , Modified on August 2, 2023 , by Yannick JaquierTable of contents Preamble DBSAT running DBSAT reporting DBSAT result References Read more Oracle Security 4 comments
Edition-Based Redefinition (EBR) for online application migration Posted on June 20, 2023 , Modified on June 20, 2023 , by Yannick JaquierTable of contents Preamble Edition-Based Redefinition (EBR) and DBMS_REDEFINITION test case Edition-Based Redefinition (EBR) testing Application preparation for EBR Creating the new edition and new edition objects Testing the new edition and crossedition triggers Using service to point to desired edition DBMS_REDEFINITION for online table redefinition References Read more Oracle DBMS_REDEFINITION, Edition-Based Redefinition (EBR), SQL Leave a comment
How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble Preparation of the test environment The old legacy technique The alter table switch technique The view technique The synonym technique The schema transfer technique Conclusion References Read more MariaDB, MySQL, Oracle, PostgreSQL, SQL Server Development, SQL Leave a comment