recyclebin

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 2 Jun 2009 20:43:03 -0500
Message-ID: <BLU108-W26FC8A74409E7464B3B736974A0_at_phx.gbl>

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 Live™: Keep your life in sync.
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:43:03 CDT