RE: recyclebin

From: Joe Smith <>
Date: Tue, 2 Jun 2009 21:09:08 -0500
Message-ID: <BLU108-W5422AF0DA2D98A3E0DB763974A0_at_phx.gbl>

Nope. Not using the purge option.  


To:; Subject: RE: recyclebin
Date: Tue, 2 Jun 2009 21:57:10 -0400

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”.  


From: [] On Behalf Of Joe Smith Sent: Tuesday, June 02, 2009 9:43 PM
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

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


Windows Live™: Keep your life in sync. Check it out.

Windows Live™ SkyDrive™: Get 25 GB of free online storage.
Received on Tue Jun 02 2009 - 21:09:08 CDT

Original text of this message