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
