Re: Create synonym

>>I have 50 or so tables, now I want to create synonym for them,
>>same name as table name. How can I do this without manully one by one?

The solution is to build the create synonym script and then execute the second file. For example, try something like this:

spool syns2.sql                                                           
select 'spool syns.lis' from dual;                              
                                                                               
select 'create synonym &1'||'.'||table_name||' for XXXX'||'.'||table_name||';' 
from sys.dba_catalog                                                           
where owner='XXXX'                                                             
and table_type != 'SYNONYM'                                                    
/                                                                              
                                                                               
select 'commit;'                                                               
from dual                                                                      
/                                                                              
                                                                               
select 'spool off' from dual;                                                  
select 'exit' from dual;                                                       
                                                                               
spool off                                                                      
start syns2.sql                                                           

--
Brian