recyclebin problem.

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Fri, 02 Nov 2007 21:56:22 GMT
Message-ID: <a2NWi.26$b%1.22@trnddc01>

oracle 10.2.0.3, recycelbin parameter is on. I drop a table in an non-system LMT but nothing is in the recyclebin. What am I missing here?

SQL> show parameter recyclebin

NAME TYPE VALUE
----------- ----------- ------------------
recyclebin string on

SQL> create table mytable as select * from dba_users;

Table created.

SQL> select tablespace_name from user_tables where table_name = 'MYTABLE';

TABLESPACE_NAME

---

USERS SQL> select count(*) from mytable;

  COUNT(*)

---

        13

SQL> drop table mytable;

Table dropped.

SQL> show recyclebin
SQL> select * from recyclebin;

no rows selected Received on Fri Nov 02 2007 - 16:56:22 CDT