Re: Is it possible to partition an existing table?

Hi Peter,

Anything's possible.

You have a couple of options that spring to mind.

1. You could simply create new partitioned table as select from old table. You can then drop and rename the partitioned table.
2. Export and Import into a pre-created partitioned table
3. You could exchange the old table into a new partitioned table (with one partition that covers all values/ranges). You can then split the partition(s) as required.
4. You could use the new 9i online redefinition package (dbms.redefinition) to recreate the table with a partitioned structure.

As always, read up on all the relative pros and cons and pick the right option for yourself.

Cheers

Richard
"Peter" <depend3_at_yahoo.com> wrote in message news:8Vaa9.87613$8o4.11647_at_afrodite.telenet-ops.be...
> Is it possible to partition an existing table without dropping it and how
do
> you do this?
>
>
Received on Mon Aug 26 2002 - 01:24:10 CDT