Partitioning a 10Tb table
Hi,
My customer has a heap table with 2 columns - a sequence (which is also the primary key of the table) and a BLOB. The table (including the BLOB) is around 10Tb in size. To make this more manageable, he wants to partition it into 1024 hash partitions, and he wants to achieve this using the online dbms_redefinition utility (although he would consider taking an outage to do this offline if it could be done within, say, 2 days). He also, as part of the same process, wants to convert the out-of-line BLOB segment to 'securefile' storage, and to
My customer has a heap table with 2 columns - a sequence (which is also the primary key of the table) and a BLOB. The table (including the BLOB) is around 10Tb in size. To make this more manageable, he wants to partition it into 1024 hash partitions, and he wants to achieve this using the online dbms_redefinition utility (although he would consider taking an outage to do this offline if it could be done within, say, 2 days). He also, as part of the same process, wants to convert the out-of-line BLOB segment to 'securefile' storage, and to
0