0

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!

0

1 Answer 1

0

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

1
  • I did not and I can not understand why I did this.. Fortunately, it has the 'sys' privilege. Is there no way? Jun 22, 2019 at 10:12

Not the answer you're looking for? Browse other questions tagged or ask your own question.