You're probably thinking of "ALTER SESSION SET CURRENT_SCHEMA ...." = command. Also, see the article 'Sin-onyms' on http://www.ixora.com.au/ Also, try searching the archive of this mailing for a recent discussion. Hope that helps, -Mark > Dear list,=20 >=20 > Using synonyms may affect database performance and=20 > scalability. Someone > from our list has suggested an oracle new something on 8.1.7.=20 > Anybody > remember? Please send me a note.=20 -- //www.freelists.org/webpage/oracle-l