Step-by-Step Guide to Deleting a Tenant in OceanBase

This article explains the background, environment setup, overall process, and detailed SQL commands required to safely lock, kill sessions, and permanently delete a MySQL tenant in OceanBase, including optional recycle‑bin handling.

Database ManagementOceanBaseOperations

0 likes · 6 min read

Step-by-Step Guide to Deleting a Tenant in OceanBase

Aikesheng Open Source Community

Mar 8, 2023 · Databases

OceanBase Tenant Deletion Methods and Syntax

This article explains OceanBase's three tenant deletion approaches—normal, delayed, and immediate—detailing the DROP TENANT syntax, recycle‑bin behavior, and providing step‑by‑step SQL examples for creating, dropping, restoring, and permanently removing tenants.

Database AdministrationOceanBaseSQL

0 likes · 7 min read

OceanBase Tenant Deletion Methods and Syntax