Xref: alice comp.databases.oracle.server:26505
Path: alice!news-feed.fnsi.net!news.idt.net!nntp2.cerf.net!gatekeeper.wdc.com!usenet
From: ngreene@usa.capgemini.com (Neil Greene)
Newsgroups: comp.databases.oracle.server
Subject: Re: Exchange Partitions
Date: Sat, 8 Aug 1998 00:37:45 -0700
Organization: Cap Gemini
Lines: 11
Message-ID: <MPG.1035a022c8ceecfa989680@gatekeeper.wdc.com>
References: <6qfcl2$m1o$1@ash.prod.itd.earthlink.net>
X-Newsreader: MicroPlanet Gravity v2.10.940

In article <6qfcl2$m1o$1@ash.prod.itd.earthlink.net>, janderson@iname.com 
says...
> We are considering using the EXCHANGE PARTITION command in Oracle8 to do
> mass updates to specific table partitions. The database needs to be up 24x7.
> What effect would exchanging the partition have on active queries across the
> partition that is being exchanged? Does Oracle allow you to exchange the
> partition when the partitioned table is online and in use? Would the users
> query just return unstable results or would it error out? If anyone has had
> experience with this issue I would appreciate your input.

Let me know what you hear.  --- Neil