converting non partition to partition table
From: Pap <oracle.developer35_at_gmail.com>
Date: Tue, 30 Mar 2021 23:44:52 +0530
Message-ID: <CAEjw_fiTTvYYEtwNeUtnHXmPGHjhHcPgdtaNUPCGVBUqJHEnYw_at_mail.gmail.com>
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 ?
Date: Tue, 30 Mar 2021 23:44:52 +0530
Message-ID: <CAEjw_fiTTvYYEtwNeUtnHXmPGHjhHcPgdtaNUPCGVBUqJHEnYw_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 30 2021 - 20:14:52 CEST