Or maybe you can have a luxury of having one logon trigger that executes alter session set current_schema? On 1/25/06, Thomas Day <tomday2@xxxxxxxxx> wrote: > Switching the schemas by changing the synonyms is ingenous. To > symplify it, why not have two databases with the same schema - > identical except for data content - and just repoint the listener? > -- Best regards, Edgar Chupit callto://edgar.chupit -- //www.freelists.org/webpage/oracle-l