Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Exchange Partitions

Re: Exchange Partitions

From: Neil Greene <ngreene_at_usa.capgemini.com>
Date: Sat, 8 Aug 1998 00:37:45 -0700
Message-ID: <MPG.1035a022c8ceecfa989680@gatekeeper.wdc.com>


In article <6qfcl2$m1o$1_at_ash.prod.itd.earthlink.net>, janderson_at_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 Received on Sat Aug 08 1998 - 02:37:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US