Re: Application architecture & prod/pre-prod switcheroos

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_at_gmail.com> 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
--
http://www.freelists.org/webpage/oracle-l