Re: Increase partition range

On 1 Mar 2005 16:04:59 -0800, stuartcharlton_at_gmail.com (Stu Charlton) wrote:

>Kenneth Koenraadt wrote in message news:<4224c230.1170609_at_news.inet.tele.dk>...
>
>> The package DBMS_REDEFINITION does offer redefiniton of tables online,
>> but that does not include repartitioning.
>
>It doesn't? Maybe I'm misunderstanding you, but that's exactly what
>one can do with DBMS_REDEFINITION.

You can *partition* a non-partitioned table. And you can *departition* a partitioned table. But AFAIK, you can't *re*partition, i.e. merge/split partitions. Haven't actually verified, the doc just does not mention such an option.

• Kenneth Koenraadt