Multitenant pluggable database cloning and moving – part 2 Posted on September 10, 2023, updated on September 19, 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 Continue reading
Multitenant pluggable database upgrade – part 1 Posted on August 21, 2023, updated 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 Continue reading
Database Security Assessment Tool (DBSAT) hands-on Posted on July 31, 2023, updated on August 2, 2023 by Yannick JaquierTable of contents Preamble DBSAT running DBSAT reporting DBSAT result References Continue reading
dbx for local and rapid development lifecycle through Databricks Posted on July 10, 2023, updated on July 10, 2023 by Yannick JaquierTable of contents Preamble Not able to access DBFS files under Databricks Connect Creation of the DBR 12.2 Conda environment DBX installation and configuration Databricks CLI installation Databricks CLI profile configuration DBX installation DBX configuration DBX execution Resolve unicode error and add icons to Git Bash DBX execution of a more complex example Synchronize your local code with Databricks References Continue reading
Edition-Based Redefinition (EBR) for online application migration Posted on June 20, 2023, updated 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 Continue reading
Data skipping and row group skipping in action with delta tables Posted on June 1, 2023, updated on June 1, 2023 by Yannick JaquierTable of contents Preamble Data skipping test case Data skipping and row chunk skipping testing References Continue reading