How can I recover a dropped table? 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!
You might want to recover the table from your database backup. You do have a backup right? - hot2use

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