The recycle bin stores objects such as databases and tables dropped by users.
The recycle bin is equivalent to a data dictionary table for storing information about objects dropped by users. Objects in the recycle bin still occupy physical space unless they are manually purged or periodically deleted by the system.
Generally, objects that can be moved to the recycle bin are indexes, tables, databases, and tenants, but there are some differences between the MySQL and Oracle modes of OceanBase Database. The following table lists these differences.
| Mode | Index | Table | Database | Tenant |
|---|---|---|---|---|
| MySQL | Supported | Supported | Supported | Supported |
| Oracle | Supported | Supported | Not supported | Not supported |
Notice
Indexes dropped by using the
DROPstatement are not directly moved to the recycle bin. When a table is dropped, the indexes on this table are then moved to the recycle bin along with the table.No DML operations can be performed on objects in the recycle bin. For DDL operations, only two of them are supported: PURGE and FLASHBACK.
Only the
systenant supports the recycle bin for tenants.