Re: Online Table Reorg

Folks should be aware that the online move option is only usable if you have an EE license:

https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.htm

See feature "Online table organization".

Rich

On Wed, Jul 7, 2021 at 12:26 AM Connor McDonald <mcdonald.connor_at_gmail.com> wrote:

> alter table MYTABLE move online
>
> You're done :-)
>
> On Tue, Jul 6, 2021 at 7:39 AM Leng Burgess <lkaing_at_gmail.com> 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_at_freelists.org> wrote:
>>
>> Wanted to check if anyone has tried online table reorg. ? What are the
>> steps ? I was looking for all steps.
>>
>>
>>
>
> --
> Connor McDonald
> ===========================
> blog: connormcdonald.wordpress.com
> twitter: _at_connor_mc_d
>
> "If you are not living on the edge, you are taking up too much room."
> - Jayne Howard
>
> *Fine print: Views expressed here are my own and not necessarily that of
> my employer*
>

--
http://www.freelists.org/webpage/oracle-l