RE: recyclebin

From: Kenneth Naim <kennaim_at_gmail.com>
Date: Tue, 2 Jun 2009 21:57:10 -0400
Message-ID: <008801c9e3ee$9d2acfc0$d7806f40$_at_com>



This may be obvious, but depending on how he is dropping it (ie custom code, or some gui) the purge option may be specified in the drop command "drop table t1 purge".  

Ken  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith
Sent: Tuesday, June 02, 2009 9:43 PM
To: oracle-l_at_freelists.org
Subject: recyclebin  

I have a user that when he drops a table it does not go into the recyclebin. I can see the segments this user created in user_segments and his table name in user_tables.  

All other users can do this. I created a user, granted create session, create table, and a ts quota on USERS and he can drop the table and it goes into the recyclebin.  

The parameters for the recyclebin are turned on and the hidden parameter is turned on ( i.e. _recyclebin= ).  

The tablespaces are LMTs and this is Oracle EE 10.2.0.4.0.

Why would this user not be able to drop a table and have it go into the recyclebin?  

thanks.


Windows LiveT: Keep your life in sync. Check it out. <http://windowslive.com/explore?ocid=TXT_TAGLM_WL_BR_life_in_synch_062009>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 02 2009 - 20:57:10 CDT

Original text of this message