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

From: Kenneth C Stahl <BlueSax_at_Unforgetable.com>
Date: Thu, 27 Jan 2000 08:00:01 -0500
Message-ID: <38904150.D9872813@Unforgetable.com>

Marc wrote:
>
> 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

You won't solve your problem by dropping and then re-creating the synonyms. It is perfectly valid to create a synonym for a non-existant object.

What would be better is if you created a program which will sweep through your synonyms and test for the existance of each underlying object. Received on Thu Jan 27 2000 - 07:00:01 CST