alter table MYTABLE move online
You're done :-)
On Tue, Jul 6, 2021 at 7:39 AM Leng Burgess <lkaing@xxxxxxxxx> wrote:
Hi Atul,
Here are some simple steps for basic tables:
1) ALTER TABLE move
2) rebuild unusable indexes
3) recompile invalid objects
Non-basic tables like IOT, LOBS, partitioned tables will have to be done a
little differently
Cheers,
Leng.
On 18 Jun 2021, at 1:36 am, Atul Choudhary (Redacted sender
"Atul.Choudhary" for DMARC) <dmarc-noreply@xxxxxxxxxxxxx> wrote:
Wanted to check if anyone has tried online table reorg. ? What are the
steps ? I was looking for all steps.