Drop permission for this table.FLASHBACK TABLE recycle_table_name TO BEFORE DROP [RENAME TO new_table_name];
Parameter | Required | Description |
recycle_table_name | Required | Alias of the table after it enters the recycle bin. The alias can be obtained through the recycle_table field in SHOW RECYCLEBIN. |
new_table_name | Optional | New name of the table when it recovers. |
TDSQL [(none)]> show recyclebin;+-----------+---------------+--------------+--------------------------------+---------------------+---------------------+| tindex_id | origin_schema | origin_table | recycle_table | drop_time | purge_time |+-----------+---------------+--------------+--------------------------------+---------------------+---------------------+| 10028 | test | test2 | bin$/usodaiwngrpdoel2wnlqg==$1 | 2025-01-21 19:12:10 | 2025-01-28 19:12:10 |+-----------+---------------+--------------+--------------------------------+---------------------+---------------------+TDSQL [(none)]> flashback table `bin$/usodaiwngrpdoel2wnlqg==$1` to before drop rename to test.test3;Query OK, 0 rows affected (1.72 sec)TDSQL [(none)]> show tables;+----------------+| Tables_in_test |+----------------+| test1 || test3 |+----------------+2 rows in set (0.01 sec)
피드백