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

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 27 Jan 2000 14:16:55 +0100
Message-ID: <86pggh$2k8v$1@news6.isdnet.net>

Set heading off
Set feedback off
Set showmode off
Set verify off
Set pagesize 0
Set termout off
Set trimout on
Set trimspool on
Set recsep off
Set linesize 1000
Set echo off
Spool drpsyn.sql
Select 'Drop synonym '||synonym_name||';' from user_synonyms where synonym_name like '%500%';
Spool off

You get in drpsyn.sql all the statements to drop your synonyms containing 500 in their name.

--
Have a nice day
Michel

Marc <mphaan_at_hotmail.com> a écrit dans le message : 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
>
>
Received on Thu Jan 27 2000 - 07:16:55 CST