Also it's quite a bit slower and using double space. DBMS_REDEFINITION
creates another object, builds it to the specifications, loads it and
then trades places with the original. It does work in the SE. However,
given the advance of the open source databases like Postgres, it is
questionable how much sense it makes to run SE. Postgres is much cheaper
and very likely good enough. Postgres can do parallelism and
partitioning, things that SE has a problem with. There is still nothing
on the planet that can match Oracle EE and its capabilities, but SE is
another story indeed.
On 7/7/21 9:07 PM, Connor McDonald wrote:
dbms_redefinition is a close equivalent to alter table move online.