If it's a regular query with different filters why not script it? SQL> @syn.sql <OWNER> <TABLE> <NAME> some smart hacks to make it pick whichever argument you use... Alan.- On Fri, Nov 30, 2012 at 6:14 PM, Gerald Cunningham < gcunningham@xxxxxxxxxxxxxx> wrote: > I need to create a synonym for dba_synonyms named dba_synonymns, because I > always misspell dba_synonyms "dba_synonymns". > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l