Re: partitioning table

From: Brian Pulcine <bpulcine_at_bellatlantic.net>
Date: Thu, 14 Jun 2001 20:00:58 GMT
Message-ID: <_J8W6.4674$xe1.906322@dca1-nnrp2.news.digex.net>

You have to create a new partition object, and load the data into it from the original table. There is no way to alter an existing table into partitions.

"steve" <E_at_E.COM> wrote in message news:1ev08v6.ingj94royqxgN%E_at_E.COM...
> Hi,
> I have a table under 8i that is currently not partitioned, I want to
> partition it.
> can I use the alter table command or do I have to re-create the table,
> but partitioned.
>
> the table is also replicated, and I do nto want to have to re-build the
> replication if I can help it.
>
> steve
Received on Thu Jun 14 2001 - 15:00:58 CDT