How to create more than one synonym at a time
I want to create a synonym for all tables in the schema in question. There are a lot of tables and I do not want to create a sysnonym for each table one by one.
I have looked in the DBconsole, but only see a means of creating one synonym at a time.
Oracle version is 10.2.0.4 in Windows 2003