All Products
Search
Document Center

PURGE RECYCLEBIN

Last Updated: Jun 18, 2021

Description

You can execute the PURGE RECYCLEBIN statement to empty the recycle bin as the root user.

Notice

The PURGE RECYCLEBIN statement deletes all objects from the recycle bin. You can execute this statement as the root user only. Proceed with caution.

Syntax

 PURGE RECYCLEBIN;

Parameters

None

Examples

  • Empty the recycle bin as the root user.

OceanBase(admin@test)> purge recyclebin;
Query OK, 0 rows affected (0.03 sec)