Why the dropped table not in recyclebin?
548150Jun 14 2008 — edited Aug 29 2012Why the dropped table not lised in recyclebin? But listed in EM console.
I think it maybe a Oracle bug.
SQL> drop table jeff.job;
Table dropped.
SQL> select*from jeff.job;
select*from jeff.job
*
'ERROR at line 1:
ORA-00942: table or view does not exist.
SQL> show recyclebin;
But from the EM console, I can find the dropped table jeff.job and I get the recyclebin name from there.
SQL> flashback table "JEFF"."BIN$T6nzNsfaiAHgQAB/AQAkGA==$0" to before drop rename to "jeff.jobs";
Flashback complete.
Message was edited by:
frank.qian