Re: 10g and Recycle Bin

From: Frederic Houbie <fh_at_ionicsoft.comNOSPAAAAM>
Date: Tue, 13 Apr 2004 17:38:29 +0200
Message-ID: <pan.2004.04.13.15.38.28.971156@ionicsoft.comNOSPAAAAM>

On Tue, 13 Apr 2004 07:17:39 -0700, Daniel Morgan wrote:

> Frederic Houbie 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
>>

> 
> Can not be done. But can you explain any reason for wanting to do so?
> And exactly what do you mean by "not really dropped"? The fact that
> it is recoverable doesn't mean it hasn't been dropped.

In fact, I have a Type, let's call it T1, it is created in SYSTEM schema by a dba user. I have created a public synonym S1 referencing T1. I dropped T1 (at that time, i didn't new the existence of recycle bin). Then, I couldn't do anything with S1, it was not in all_synonyms view, I could not drop it, but could not create a synonym with the name S1 anymore, because I suppose it was still linked in a way to the 'dropped' type T1. Once I purge the recycle bin, I could create the synonym with the name S1.

Fred Received on Tue Apr 13 2004 - 10:38:29 CDT