Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 10g and Recycle Bin
On Tue, 13 Apr 2004 07:17:39 -0700, Daniel Morgan wrote:
> Frederic Houbie wrote:
> > 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
![]() |
![]() |