Re: Online Table Reorg
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 7 Jul 2021 22:38:38 -0400
Message-ID: <2bb2a2b8-f724-f6a6-11c0-b80b883b20b3_at_gmail.com>
Date: Wed, 7 Jul 2021 22:38:38 -0400
Message-ID: <2bb2a2b8-f724-f6a6-11c0-b80b883b20b3_at_gmail.com>
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.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 08 2021 - 04:38:38 CEST