Re: partitioning an exesting table

On 10 Aug 2005 14:10:48 -0700, "Eugene" <epipko_at_hotmail.com> wrote:

>Hi all,
>I am using Oracle 9.2 enterprice addition on Win2003.
>I am looking a way to partition an existing (packaged application)
>table with 3M rows. It has 24 indexes and 2 triggers on it as well.
>Could you, please refer me to the doc or show me the way of doing it?
>
>Thanks,
>Eugene

Hi Eugene,

Take a look at the DBMS_REDIFINITION built-in package, which allows you to partition the table online. Your table must have a primary key defined on it.

• Kenneth Koenraadt