Re: help: dropping synonyms

From: Harish Ramachandran <prabhs_at_po.pacific.net.sg>
Date: 1996/10/31
Message-ID: <55a8mb$7s7_at_newton.pacific.net.sg>#1/1


You can create a script which will drop all public synonyms. Use the following SQL to generate the script.

select 'drop public synonym ' || synonym_name || ';' from all_synonyms
where table_owner = 'actual owner'

Run the above script using SQL*Plus and spool it on to a file. Then execute the file from SQL*Plus.

Second method is to use dbms_sql database procedure by which you can do any DDL statements. This is applicable only on Oracle 7.x.

Hope it helps you

Regards

N.Prabhakar
Socgen Crosby Securities, Singapore
Email : prabhs_at_pacific.net.sg Received on Thu Oct 31 1996 - 00:00:00 CET

Original text of this message