Oracle Database - Recycle Bin (Flashback Drop)

> Database > Oracle Database

1 - About

When you drop a table, the database does not immediately remove the space associated with the table. The database renames the table and places it and any associated objects in a recycle bin, where, in case the table was dropped in error, it can be recovered at a later time.

Advertising

3 - Management

3.1 - Select

SELECT * FROM RECYCLEBIN;

DBA_RECYCLEBIN

4 - Documentation / Reference