Understanding Flashback Technology - OCP: Oracle Database 12c Administrator Certified Professional - page 364

exeRCiSe 8.1
Purging a Table from the Recycle Bin
To purge a table from the Recycle Bin, do the following:
1. Create a table and add rows of data.
SQL> create table foo (x number, y varchar2(10)) tablespace users;
Table created.
SQL> insert into foo values (1,'test1');
1 row created.
SQL> insert into foo values (2,'test2');
1 row created.
SQL> insert into foo values (3,'test3');
1 row created.
SQL> commit;
Commit complete.
2. Drop the table.
SQL> drop table foo;
Table dropped.
3. Verify that the table exists in the Recycle Bin.
SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
FOO BIN$3xVo45MkQpycedOi7/2Jgg==$0 TABLE 2013-09-16:12:59:28
4. Purge the table from the Recycle Bin.
SQL> purge table foo;
Table purged.
5. Verify that the table is no longer in the Recycle Bin.
SQL> show recyclebin;
SQL>