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 clears all objects in the recycle bin. You can execute this statement only as the root user. 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)