Re: Online Partition addition use "add partition" clause or "reorganize" clause?

[Mikael Ronström]

Tom Song Wrote:
-------------------------------------------------------
> Hi Rick James,
>
> Thank you for your help.
>
> As your response that can do the reorganize
> online, will use it to add partition online.

No partition change operation are truly on-line,
the table is still readable but not writeable
for a short time. However as mentioned when the
partition that you reorg is empty, it is a very
quick operation which will complete in probably
less than a second, so it is practically online.

Also all other partition change operations
minimise the amount of time for changing
the table since only the relevant parts of
the table are reorganised.

Rgrds Mikael Ronström