Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Merging Partitions on Oracle 8i
A copy of this was sent to "Ming" <fungs_at_logica.com>
(if that email address didn't require changing)
On Mon, 14 Jun 1999 12:46:41 +0100, you wrote:
>Hi all
>
>I currently trying to merge partitions on Oracle 8i , but can't find much
>information in the standard documentation. Can anyone help.
>
http://technet.oracle.com/doc/server.815/a67779/ch4d.htm#63232 (you need a password for technet -- they are free, goto http://technet.oracle.com/ to get one)
>Also how much of an overhead is merging two partitions, especially with a
>number of indexes.
It is a complete rewrite of the data.
>Do these have to be rebuilt ?
>
Yes.
>Cheers.
>
There isn't tons of documentation on it because its mostly about syntax (merge is what it is). Merging 2 partitions will take two existing partitions and rewrite them into a new one -- thats all it does. The docs do say that :
<quote>
If either or both of the original partitions was not empty, Oracle marks
UNUSABLE all global nonpartitioned global indexes and all partitions of global
indexes on the table. In addition, if the partition or any of its subpartitions
resulting from the merge is not empty, Oracle marks UNUSABLE all corresponding
local index partitions and subpartitions.
</quote>
See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/
Current article is "Fine Grained Access Control", added June 8'th
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA--