Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> recyclebin problem.
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
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
![]() |
![]() |