Re: 8i (8.1.5) - Add Partitions to previously Non-Partitioned Table containing data ???

I am fairly sure that there is currently no way to do this - I did have a quick look to see if 'alter table move' will allow you to rebuild the table with partitioning clauses, but it doesn't.

You can do:

    create table .... partitioned ...... then

    alter new_table exchange partition XXX with old_table .... if your current table belongs in a single partition; this would be quicker than create as select.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Christian Roig wrote in message <380d7c7b.3038068_at_news.tele.dk>...
>8i (8.1.5) - Add Partitions to previously Non-Partitioned Table
>containing data ???
>
>Is it possible to use the Alter Table command to add partitions to a
>table that contains data and was not previously partitioned ???
>
>Or do I have to do a 'Create Table As Select' with Partition creation
>statements ???
>
>I have looked at the Oracle documentation, but I don't thnk that it is
>stated very clearly wether or not it is possible to use the Alter
>Table command to add partitions to a table that contains data and was
>not previously partitioned.
>
>TIA - Christian
Received on Wed Oct 20 1999 - 17:38:35 CDT