obclient> SHOW VARIABLES LIKE ‘%recyclebin%‘;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| recyclebin | OFF |
+---------------+-------+
1 row in set (0.01 sec)
obclient> SET @@RECYCLEBIN=ON;
Query OK, 0 rows affected (0.00 sec)
obclient> SHOW VARIABLES LIKE ‘%recyclebin%‘;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| recyclebin | ON |
+---------------+-------+
1 row in set (0.00 sec)
obclient> SHOW RECYCLEBIN;
Empty set (0.01 sec)
obclient> CREATE TABLE test1 AS SELECT * FROM t1;
ERROR 1046 (3D000): No database selected
obclient> USE test;
Database changed
obclient> CREATE TABLE test1 AS SELECT * FROM t1;
Query OK, 1 row affected (0.13 sec)
obclient>
obclient>
obclient> SHOW VARIABLES LIKE ‘RECYCLEBIN‘
->
-> ;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| recyclebin | ON |
+---------------+-------+
1 row in set (0.01 sec)
obclient>
obclient>
obclient> SHOW RECYCLEBIN;
Empty set (0.00 sec)
obclient> DROP TABLE test1;
Query OK, 0 rows affected (0.02 sec)
obclient> SHOW RECYCLEBIN;
+--------------------------------+---------------+-------+----------------------------+
| OBJECT_NAME | ORIGINAL_NAME | TYPE | CREATETIME |
+--------------------------------+---------------+-------+----------------------------+
| __recycle_$_3_1630659246143488 | test1 | TABLE | 2021-09-03 16:54:06.144186 |
+--------------------------------+---------------+-------+----------------------------+
1 row in set (0.01 sec)
obclient>
https://www.oceanbase.com/docs/oceanbase-database/oceanbase-database/V2.2.30/objects-supported-by-recycle-bin