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@hotmail.com> wrote in message
news:UxTj4.266$kJ6.750@198.235.216.4...
> 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
>
>