Oracle 10g Recycle Bin

[artm...@gmail.com]

Hi,

I've read all about Oracle uses the recycle bin and how it purges
objects when it needs space, etc. But, is there any way to manually
control that, meaning to keep the objects in there longer? Other than
increasing the size of the tablespace??

Thanks

[The Boss]

Now why would you want to do that?
You're sure to have read all about the purpose of the recycle bin?
You seem to confuse it with that of an archive or a backup.

--
Jeroen

[Palooka]

Perhaps I am a Luddite, but IMHO anyone with even a half decent version
control/change control regime has absolutely no need of a recyclebin.
Who in their right minds needs to undrop a dropped object?
Why Oracle even introduced it I cannot imagine. Sheesh. Windoze anyone?
Rant over.

Palooka

[joel garry]

On Dec 1, 3:23 pm, Palooka <nob...@nowhere.com> wrote:

So you are saying anyone with access to a SQL prompt is not in their
right mind? I agree! :-)

I'd go out on a limb and say most places don't have decent version
control.

Even so, you might want to give developers access to their own
environment, where they can screw up to their hearts content.

I know I still take exports, mostly for user errors, but damagers are
users too, only with the ability to override any controls. Then
there's clumsy ol' me...

jg
--
@home.com is bogus.
Hand me that saw.

[Palooka]

Oh, in Dev, they can have a free for all, or each developer can have
his/her own schema, or whatever suits them best.
Not a problem at all as far as I am concerned. But promotion from there
to an environment where there are multiple testers...control is needed.

Palooka