Examine the following commands executed in your database:
SQL> ALTER SESSION RECYCLEBIN=ON;
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;
Further, you executed the following command to drop the table:
SQL> DROP TABLE emp;
What happens in this scenario?
The table is moved to the SYSTEM tablespace.
The table is renamed and remains in the TBSFD tablespace.
The table is moved to the SYSAUX tablespace.
The table is removed from the database permanently.