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

spool script.sql

select 'create public synonym ', table_name, ' for owner||'.'||table_name from user_tables;

(or from all_tables where owner = 'schema') spool off

...generates the file you have to use.
Hth, Reiner

"Carlos Lacasa" <clacasa_at_sestra.es> schrieb im Newsbeitrag news: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