Re: Oracle generated tables in 10g?

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Wed, 14 Apr 2004 23:55:52 +0300
Message-ID: <407da55a_1@news.estpak.ee>

There's also a hidden parameter _recyclebin in final version of 10g, if you set it false, then tables are purged immediately, even when you don't specify the "purge" option.

This parameter is settable also at session level.

But anyway, I don't see a big problem with the recyclebin, because (supposedly) the dropped segments are purged automatically if tablespace runs out of space or user runs out of quota.

Tanel.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:c5jgvg$7gf$1_at_sparta.btinternet.com...
>
> Look up "recyclebin"
> Also
> purge recyclebin;
> drop table XXX purge;
>
> This is the Oracle equivalent of the
> Windows waste basket. As Yogi Berra
> would not have said:
>
> It's not dropped until it's purged.
Received on Wed Apr 14 2004 - 15:55:52 CDT