Problem solved. If there is a security policy defined on a table it does not go into the recyclebin. thanks. From: peters@xxxxxxxxx To: oracle-l@xxxxxxxxxxxxx Date: Wed, 3 Jun 2009 10:39:16 -0400 Subject: Re: recyclebin There is no guarantee of retention for items in the recycle bin. If the space is needed for something it could get reused at any time, and certainly before the tablespace extension comes into play. There are supposedly some rules in place whereby Oracle attempts to reuse older objects first, but not sure it this is explicitly documented. --Peter _________________________________________________________________ Lauren found her dream laptop. Find the PC that’s right for you. http://www.microsoft.com/windows/choosepc/?ocid=ftp_val_wl_290