RDBPROD: What Is The Best Way To Reorganize A Partitioned Table In Mixed Area To Partitioned Uniform Area
(Doc ID 470983.1)
Last updated on FEBRUARY 06, 2020
Applies to:Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS VAX
HP OpenVMS Itanium
HP OpenVMS Alpha
This document describes ways to reorganize a table with about 20 million records partitioned in 3 mixed areas, with compression enabled, into a table partitioned in 4 uniform areas with compression disabled. What is the fastest way to do this?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
Via ALTER STORAGE MAP REORGANIZE
Unload and truncate the table, then do an alter storage map and reload.
Unload and drop the table, create the table and the new storage map and reload.
Drop mixed areas before load: