Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10g and Recycle Bin

Re: 10g and Recycle Bin

From: <Kenneth>
Date: Tue, 13 Apr 2004 14:05:24 GMT
Message-ID: <407bf1dd.421796@news.inet.tele.dk>


On Tue, 13 Apr 2004 14:44:30 +0200, Frederic Houbie <fh_at_ionicsoft.comNOSPAAAAM> wrote:

>Hi all,
>
>can anybody tell me how to disable the Recycle Bin (Flashback
>capabilities) on a user. I've searched a long time for a problem because
>the object was not really dropped but in the recycle bin. As far as I'm in
>a development process, I would like to disable this.
>
>Thanks
>
>Frederic
>

DROP TABLE <TABLENAME> PURGE;

bypasses the recycle bin.

AFAIK, you can't disable the recycle bin for a user.

Received on Tue Apr 13 2004 - 09:05:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US