Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> recyclebin problem.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US