Re: 10g and Recycle Bin

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 13 Apr 2004 10:12:33 -0700
Message-ID: <1081876340.991965@yasure>

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

As was stated by someone earlier ... the new syntax is:

DROP TABLE <table_name> PURGE;

To irreversibly drop a table.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Apr 13 2004 - 12:12:33 CDT