Re: Online Table Reorg

Fortunately the ONLINE option fails if you’re on SE rather than just letting you go ahead and deal with the licensing folks!

SQL> alter table neons.LLT_SEQ_OFFSET move tablespace NEONS online; alter table neons.LLT_SEQ_OFFSET move tablespace NEONS online *
ERROR at line 1:
ORA-00439: feature not enabled: Online Index Build

> On 7 Jul 2021, at 11:04 pm, Rich J <rich242j_at_gmail.com> wrote:
>
> 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 <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 <mailto: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 <mailto: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 <mailto: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.

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