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!

Best Answer

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