OceanBase 支持回收站功能，通过回收站可以闪回已删除的表。默认回收站是开启的，回收站是否开启由租户变量 recyclebin 控制。

    开启/关闭回收站的语法是：

    1. set global recyclebin = ON | OFF ;

    修改回收站的开启状态后，只对后续新连接会话生效。

    • 示例：闪回被删除的表。
    1. obclient> create table t1(id number not null primary key, gmt_create date not null default sysdate);
    2. Query OK, 0 rows affected (0.09 sec)
    4. obclient> insert into t1(id) values(1),(2),(3);
    5. Query OK, 3 rows affected (0.02 sec)
    6. Records: 3  Duplicates: 0  Warnings: 0
    8. obclient> select * from t1;
    9. +----+---------------------+
    10. | ID | GMT_CREATE          |
    11. +----+---------------------+
    12. |  1 | 2020-04-02 18:20:49 |
    13. |  2 | 2020-04-02 18:20:49 |
    14. |  3 | 2020-04-02 18:20:49 |
    15. +----+---------------------+
    16. 3 rows in set (0.00 sec)
    18. obclient> drop table t1;
    19. Query OK, 0 rows affected (0.03 sec)
    21. obclient> show recyclebin;
    22. +-------------------------------------+------------------------------------+-------+----------------------------+
    23. | OBJECT_NAME                         | ORIGINAL_NAME                      | TYPE  | CREATETIME                 |
    24. +-------------------------------------+------------------------------------+-------+----------------------------+
    25. | RECYCLE_$_20200102_1585822884952336 | T1                                 | TABLE | 2020-04-02 18:21:24.952475 |
    26. +-------------------------------------+------------------------------------+-------+----------------------------+
    27. 1 rows in set (0.01 sec)
    29. obclient> flashback table RECYCLE_$_20200102_1585822884952336 to before drop rename to t1;
    30. Query OK, 0 rows affected (0.02 sec)
    32. obclient> select * from t1;
    33. +----+---------------------+
    34. | ID | GMT_CREATE          |
    35. +----+---------------------+
    36. |  1 | 2020-04-02 18:20:49 |
    37. |  2 | 2020-04-02 18:20:49 |
    38. |  3 | 2020-04-02 18:20:49 |
    39. +----+---------------------+
    40. 3 rows in set (0.00 sec)