You can execute the PURGE RECYCLEBIN statement to empty the recycle bin as the root user.
The PURGE RECYCLEBIN statement clears all objects in the recycle bin. You can execute this statement only as the root user. Proceed with caution.
- Empty the recycle bin as the root user.
OceanBase(admin@test)> purge recyclebin; Query OK, 0 rows affected (0.03 sec)