Re: partitioning table

Hi,

Mark Townsend <markbtownsend_at_home.com> wrote:

> in article 1ev08v6.ingj94royqxgN%E_at_E.COM, steve at E_at_E.COM wrote on 6/14/01
> 3:35 AM:
>
> > 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.
>
> In Oracle8i you will have to re-create the table and re-populate it. In
> Oracle9i you can effectively 'alter' it online. Note that it doesn't really
> make a lot of sense to partition an table unless you are also going to put
> each partition into a new tablespace - what are you trying to achieve by
> partitioning ?
>
> > 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 - 22:00:48 CDT