Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Exchange Partitions
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.
Thanks,
Jeff Anderson
Received on Fri Aug 07 1998 - 12:08:16 CDT