• 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

  • 相关阅读:
    shell 知识点
    辅助字符串处理类:org.apache.commons.lang3.StringUtils
    post请求(headers里有属性)报错:Request header field xxx is not allowed by Access-Control-Allow-Headers in preflight response
    vue-cli 打包报错:Unexpected token: punc (()
    遍历对象,并对其中第一个(随机)进行处理
    JavaScript中类似PHP的uniqid()方法
    使用crypto-js的md5加密
    Yarn、MapReduce、spark、storm的关系
    hadoop 知识点
    spring cloud 知识点
  • 原文地址:https://www.cnblogs.com/shenggong/p/15223878.html
Copyright © 2020-2023  润新知