• oceanbase数据库开启回收站功能


    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

  • 相关阅读:
    java内部类
    重新回顾JSP
    vs 链接动态库 (不用放在可执行文件同一目录)
    c++ 文件夹读取文件
    为人处世
    Windows常用软件
    windows好用的软件
    冒泡排序,快速排序,归并排序
    最大公约数、最小公倍数、所有约数
    linux U盘 硬盘 unable to mount
  • 原文地址:https://www.cnblogs.com/shenggong/p/15223878.html
Copyright © 2020-2023  润新知