Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting synonyms
Thanks! Does it work on Oracle v7.3.4. (I think on "execute immediate"
command)?
-- Stjepan Brbot "Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message news:Xns924E165F5CF22gnuegischgnueg_at_130.133.1.4...Received on Thu Jul 18 2002 - 00:32:01 CDT
> > How can I delete all synonyms owned by one particular user?
>
>
> like this?
>
> declare
> v_schema varchar2(30) := 'your_user_name';
> begin
> for r in (select synonym_name from user_synonyms) loop
> dbms_output.put_line(r.synonym_name);
> execute immediate 'drop synonym ' || v_schema || '.' ||
r.synonym_name;
> end loop;
> end;
> /
>