From: | "Michael Black" <mblack(at)texas(dot)net> |
---|---|
To: | pgsql-questions(at)postgresql(dot)org |
Subject: | Re: how to: list of synonyms (Oracle)? |
Date: | 2000-01-29 16:53:05 |
Message-ID: | 2VEk4.56942$Lf2.1541427@news6.giganews.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-01-29 16:58:51 | Re: [GENERAL] Quick function question |
Previous Message | Ulf Mehlig | 2000-01-29 14:48:18 | time zone problem. |