操作回收站表对象

通过回收站表名RECYCLE_NAME进行表数据查询，其余DML/DDL操作均不支持。

示例

sql

-- 创建表并插入数据
SQL> CREATE TABLE index_table1(a INT,b VARCHAR,c INT,CONSTRAINT pk_table1 PRIMARY KEY(a));   

SQL> INSERT INTO index_table1 (a, b, c) VALUES 
    (2, 'Bob', 40),
    (3, 'Charlie', 50),
    (4, 'David', 60);

-- 删除表
SQL> DROP TABLE index_table1; 

-- 查询回收站中被删除表的RECYCLE_NAME
SQL> SELECT * FROM RECYCLEBIN;

DB_ID | USER_ID | OBJECT_ID | RELATEDOBJ_ID | OBJECT_TYPE | OBJECT_TYPE_NAME | SCHEMA_ID | OBJECT_NAME | RECYCLE_NAME | DROPED_TIME | CAN_UNDROP | CAN_PURGE | RESERVED1 | 
------------------------------------------------------------------------------
1 | 1 | 1048723 | 1048723 | 5 | Table| 1 | INDEX_TABLE1| BIN$0800020014| 2024-12-02 11:03:47.439 AD | YES| YES| <NULL>|
1 | 1 | 1048724 | 1048723 | 10 | Index| 1 | PK_IDX_S7349173313740585| BIN$0E00010010| 2024-12-02 11:03:47.439 AD | NO| YES| <NULL>|   

-- 查询RECYCLE_NAME
SQL> SELECT*FROM "BIN$0800020014";

A | B | C | 
------------------------------------------------------------------------------
2 | Bob| 40 |
3 | Charlie| 50 |
4 | David| 60 |

操作回收站表对象 ​

示例 ​

操作回收站表对象

示例