Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unused Synonyms
delete them all, wait till someone complains then put that noe back :-)
seriuisly though, you cant tell if they are used or not - you can only work out if they map back to an actual object or not
On 19/10/06, Amrish Kothari (RBIN/EDM1) <Amrish.Kothari_at_in.bosch.com> wrote:
>
> Hello All,
>
> How can i find in the database al the synonyms which are not used or
> unused , but exists in the database. ?
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 19 2006 - 04:27:28 CDT