Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: creating public synonyms for a set of tables (newbie)

Re: creating public synonyms for a set of tables (newbie)

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/04/17
Message-ID: <8detrm$165q$1@news5.isdnet.net>#1/1

Set feedback off
set pagesize 0
spool create_syn.sql
select 'create public synonym '||table_name||' for '||table_name||';' from user_tables;
spool off
set feedback on
@create_syn.sql

--
Have a nice day
Michel


Carlos Lacasa <clacasa_at_sestra.es> a écrit dans le message : 8deohq$5k1$1_at_lola.ctv.es...

> Hi all,
>
> I want to generate public synonyms for a set of tables under a schema, and
> I need help to build an script to do so in one time.
>
> In pseudo-code, it would be something like:
>
> for each table in schema.Tables do
> {
> create public synonym table for schema.table;
> }
>
> Thanks in advance,
>
> Carlos Lacasa.
>
>
Received on Mon Apr 17 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US