Re: how to: list of synonyms (Oracle)?

There is a table called all_synonyms that will list all the synonyms.
In this table is a column called "owner" this is the schema in which
the object exists.

I recommend that you invest the $50.00 US an get a good Oracle book
or check the Oracle site for the free databases, or purchase the cd for
$79.00 that contains all the documentation, complete database and
extras.

"Marc" <mphaan(at)hotmail(dot)com> wrote in message
news:UxTj4(dot)266$kJ6(dot)750(at)198(dot)235(dot)216(dot)4(dot)(dot)(dot)
> Hi folks,
>
> I've got a corrupt synonym on my database. Problem is, I got a whole lot
of
> synonyms and I dont know which one is corrupt. So I want to delete or drop
> all synonyms that contain 500 in the name.
>
> Question: How can I get a list of synynyms from e certain schema level?
>
> Marc
>
>