Re: partitioning table

From: Mark Townsend <markbtownsend_at_home.com>
Date: Fri, 15 Jun 2001 01:34:29 GMT
Message-ID: <B74EB434.15A5F%markbtownsend@home.com>

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 - 20:34:29 CDT