Why 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

I doubt it. I suspect a pebcak but no bug. You may wish to review:

1) the appropriate documentation at http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2380 and http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12041.htm#i2699447
2) the userid you are using when doing this.


Remember that SHOW is a SQLPlus command, not a SQL command. You need to look at the SQLPlus manual for the SHOW command, and you might note that SHOW RECYCLEBIN
is designated for the USER_RECYCLEBIN, not the DBA_ one

Then you'd have to query DBA_RECYCLEBIN, not RECYCLEBIN. As Hans points out, SHOW RECYCLEBIN shows the contents of USER_RECYCLEBIN, which only shows you the dropped objects that were owned by the current user.

Additionally, testing recyclebin functionality using the SYS account (SYSDBA is a role, not a user) is probably an error-- objects owned by SYS don't show up in the recyclebin.

Justin

so,dropping table by sys account bypasses recyclebin and directly deleted.
Is it true?

I made a test.
if I create table by user sys, which belongs system tablespace, when I drop it, there is nothing in recyclebin.it is directly deleted.

Or why do not put user's objects into the SYSTEM tablespace :

SQL> show user

USER is "SCOTT"

SQL> sho recyclebin

SQL> create table foo(a number) tablespace system;



Table created.



SQL> drop table foo;



Table dropped.



SQL> sho recyclebin

SQL> create table foo(a number) tablespace users;



Table created.



SQL> drop table foo;



Table dropped.



SQL> sho recyclebin

ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME


------------------------------

-------------------

FOO              BIN$4lSCQj3kR1ejQ0STqEJ/BA==$0 TABLE        2008-06-15:17:19:08

SQL>

Nicolas.

Thanks to Paul for the table's name
And good luck for Tuesday evening !
Message was edited by:
N. Gasparotto

if I create table by user sys, which belongs system tablespace, when I drop it, there is nothing in recyclebin.it is directly deleted.

Well I guess that's what I said in my reply,Paul and Nicolas demonstrated.
Hope you are clear now.
Aman....

Ricardinho,
Your welcome .
Aman....