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? -- //www.freelists.org/webpage/oracle-l