Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exchange Partitions
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