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

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Thu, 27 Jan 2000 10:38:12 GMT
Message-ID: <86p76l$9t$1@nnrp1.deja.com>

SQL> desc all_synonyms;

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30
 SYNONYM_NAME                    NOT NULL VARCHAR2(30
 TABLE_OWNER                              VARCHAR2(30
 TABLE_NAME                      NOT NULL VARCHAR2(30
 DB_LINK                                  VARCHAR2(12

SQL> select synonym_name from all_synonyms where owner='PUBLIC' and table_owner='SCOTT';

SYNONYM_NAME

---

S
S2
SQLPP_HELP
SQLPP_OUTPUT regards,
M. Armaghan Saqib

+---------------------------------------------------------------
| 1. SQL PlusPlus => Add power to SQL Plus command line
| 2. SQL Link for XL => Integrate Oracle with XL

| 3. Oracle CBT with sample GL Accounting System | Download free: http://www.geocities.com/armaghan/

+---------------------------------------------------------------

Marc <mphaan_at_hotmail.com> wrote in message news:zwTj4.265$kJ6.783_at_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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 27 2000 - 04:38:12 CST