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
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