Why not use SQL to generate the synonym statement. set a spool file the try this statement:

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

That will generate the statements to create all synonyms for all tables owned by the user. If run the way it is here you will need to edit the file for echo headers and feedback so turn them off first if you want to.


Gary