Shulou(Shulou.com)06/01 Report--

Check whether the Recycle Bin is open. It is open by default.

SQL > show parameter recy

NAME TYPE VALUE

Buffer_pool_recycle string

Db_recycle_cache_size big integer 0

Recyclebin string on

Create tables, insert data, and delete

SQL > create table tmp_a (a number)

Table created.

SQL > insert into tmp_a values ('1')

1 row created.

SQL > commit

Commit complete.

SQL > drop table tmp_a

Table dropped.

Query the Recycle Bin content

Select * from user_recyclebin

Select * from dba_recyclebin

Flashback the recycle bin meter

SQL > flashback table tmp_a to before drop

Flashback complete.

After another query, the table and data are still there.

SQL > select * from tmp_a

A

one

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.