Re: converting non partition to partition table

You don't say whether the indexes are local, global, or globally partitioned, and that's always worth knowing.

If you choose option 1 then you can create any local indexes unusable then alter each partition of each index usable in separate sessions - which means you can recreate the indexes at the maximum rate your hardware can handle.

Regards
Jonathan Lewis

On Tue, 30 Mar 2021 at 19:15, Pap <oracle.developer35_at_gmail.com> wrote:

> Hello Listers, Its oracle version 11.2.0.4 database hosted on exadata X5
> machine. We have a non partitioned table having size ~4TB holding
> ~10billion rowsand 4 different indexes on it including one primary key. We
> want to convert it into a range partition table. We have flexibility to
> afford downtime for this operation. So I want to understand what is
> the best approach for achieving this? If ,
> 1) We should create a new blank table with range partitions. And then
> insert all 10billion rows into it in parallel direct path mode and
> then create local indexes and after that drop the original table ?
> OR
> 2) follow dbms_redefinition considering the table is too big ?
>
> Thanks
> Pap
>

--
http://www.freelists.org/webpage/oracle-l