Re: dropping public synonyms?

From: Sheilah Scheurich <scheuric_at_sprynet.com>
Date: 1997/05/06
Message-ID: <336ea32f.4927761_at_news.interserv.com>#1/1


On 5 May 1997 17:18:29 GMT, kirill_at_cs.ualberta.ca (Kirill Richine) wrote:

>Hi!
>
>I was wondering if it is possible to drop public synonyms created by
>an oracle user. The drop user cascade does not do it. Would I have to
>do it manually for each synonym? If yes, then which table are they in
>and what would be the cleanest way to remove them?
>
>Thank you.
>k&
>

try this:

set feedback off
set pagesize 0
spool out.sql
[Quoted] [Quoted] select 'drop public synonym '||synonym_name||';' from dba_synonyms where owner = &owner;
spool off
_at_out.sql

Should work... It may create a few errors at the end, but this will work.

sheilah scheurich
dba
scheuric_at_sprynet.com Received on Tue May 06 1997 - 00:00:00 CEST

Original text of this message