Flash back in oracle-retrieve the accidentally deleted table

Flash back in oracle-recovering the accidentally deleted table in oracle is not directly deleted after the table is dropped, but saved in the recycle bin of the current user. (If the recycle bin is full, it will be cleared in the first-in-first-out order ). The specific retention time is 15 minutes by default. I did not try. Under www.2cto.com is an online section "querying the undo_retention parameter. This parameter stores the data stored in the rollback segment in seconds. If this parameter is exceeded, the data cannot be flashed back. The default value is 15 minutes to modify the parameter alter system set undo_retention = 3600; "SQL code create table testtable (CAR_STATION_ID VARCHAR2 (255) not null, NAME NVARCHAR2 (500 ), TAX_CODE VARCHAR2 (255), INDEX_ID INTEGER) select * from testtable drop table testtable -- flashback table testtable to before drop; note: the truncate method in the truncate table testtable is to directly release resources without entering the recycle bin, which is equivalent to directly deleting windows.