• DB_RECYCLE_CACHE_SIZE: Parameter specifying the size of the RECYCLE Buffer Pool (Default: 0)

• USE_RECYCLEBIN: Parameter that provides recovery functionality when an object is dropped by user mistake (Default: N) --> Must be set to Y

1. Sample Table and Data Insert

SQL> conn tibero/tmax
Connected to Tibero.

SQL> Create table flashback_test (col1 number);   


Table 'FLASHBACK_TEST' created.


SQL> Insert into flashback_test select level as col1 from dual connect by level <= 1000;


1000 rows inserted.


SQL> commit;


Commit completed.

2. Drop Table Execution

SQL> drop table flashback_test;

Table 'FLASHBACK_TEST' dropped.

3. Create Table with the Same Name as the Original Table

SQL> create table flashback_test (col1 number);

Table 'FLASHBACK_TEST' created.

4. Execute Flashback Table Query

SQL> flashback table flashback_test to before drop; 
TBR-7312: Original name being used. 

-> Flashback table cannot be used with the same table name because the original table name is currently in use

5. Execution Using Flashback Table rename to Option

SQL> flashback table flashback_test to before drop rename to flashback_test1;

Flashbacked.


SQL> select count(*) from flashback_test1;


  COUNT(*)
––––––––––
      1000


1 row selected.