# How to recover a dropped table?

oracle-12c

I am using Oracle 12c Standard Edition.

I accidentally drop the table and try to recover it, but the table does not appear in Recyclebin.

I think the tablespace is due to SYSTEM.

Create table test(
aaa varchar2(20)
....
)
TABLESPACE SYSTEM
STORAGE (
NEXT 1024K
)
/


thank!

The real question is: why are you creating tables in the SYSTEM tablespace? Don't do that. - a-horse-with-no-name