how to: list of synonyms (Oracle)? - Mailing list pgsql-general

From Marc
Subject how to: list of synonyms (Oracle)?
Date
Msg-id UxTj4.266$kJ6.750@198.235.216.4
Whole thread Raw
List pgsql-general
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



pgsql-general by date:

Previous
From: Mark Jewiss
Date:
Subject: Re: [GENERAL] reverse sorting
Next
From: Sarah Officer
Date:
Subject: Re: [ADMIN] ugly name clash