partitioning a non-partitioned table

From: "Suresh Chaganti" <chaganti.suresh@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Mon, 27 Aug 2007 08:44:39 -0500

Hello

Can any one point me to a doc on partitioning a non-partitioned table. I
couldnt find one on metalink

I know we can use DBMS_REDEFINITION package startin 9i. But this has several
restriction including inability to use materialized views, LONG columns
etc..Also I have some 8i databases as well.

Even if I need to take the table offline, it is ok, but I am looking for
definitive guidance on the methodology to ensure all the indexes,
constraints will be intact after re-org.

Thank you

Suresh

Follow-Ups:

Re: partitioning a non-partitioned table
From: Dennis Williams

partitioning a non-partitioned table

Other related posts: