Reply-To: "news magma" From: "news magma" Newsgroups: comp.databases.oracle.server Subject: Swapping between two Schema instances on a live system Lines: 15 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: Date: Wed, 12 Dec 2001 23:12:23 GMT NNTP-Posting-Host: 64.26.131.154 X-Trace: news 1008198743 64.26.131.154 (Wed, 12 Dec 2001 18:12:23 EST) NNTP-Posting-Date: Wed, 12 Dec 2001 18:12:23 EST Organization: Magma Communications Ltd. Path: news.easynews.com!easynews!news.directnews.net!cyclone2.usenetserver.com!usenetserver.com!feed2.onemain.com!feed1.onemain.com!newsfeed.direct.ca!look.ca!news1.tor.metronet.ca!nntp.magma.ca!news!not-for-mail Xref: easynews comp.databases.oracle.server:127976 X-Received-Date: Wed, 12 Dec 2001 16:12:41 MST (news.easynews.com) Is there a recommended approach to swapping between two database schemas on a live system? We have two schema instances up and running A-Live B-Swap. We are considering an approach that would change the active sessions schema and would change the default schema for the application user account on next logon/connect I was wondering if anyone had any success with this approach? If so what would happen to in progress transactions if the schema were to change in the middle of the transcation? Cheers Dean