RE: recyclebin
- From: Joe Smith <joe_dba@xxxxxxxxxxx>
- To: <peters@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 6 Jun 2009 10:22:01 -0500
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
Other related posts: