 |
Ram Srinivasan |
at Jul 28, 2008 at 6:13 pm
|
⇧ | 
| |
Yes. Unless you purge them, Oracle will leave objects in the recyclebin
until the tablespace runs out of space, or until you hit your user quota on
the tablespace. At that point, Oracle purges the objects one at a time,
starting with the ones dropped the longest time ago, until there is enough
space for the current operation. If the tablespace data files are AUTOEXTEND
ON, Oracle will purge recyclebin objects before it autoextends a datafile.
Ram Srinivasan
On Mon, Jul 28, 2008 at 1:50 PM, Jeffrey Beckstrom wrote:
Will the recycle bin automatically be purged if the tablespace is full
and another extent is requested?
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
Sincerely
Ram Srinivasan
--
http://www.freelists.org/webpage/oracle-l
