Re: Online Table Reorg

dbms_redefinition is a close equivalent to alter table move online. Also the ORDER BY parameter in there lets you do some hown grown data clustering if needed

On Thu, Jul 8, 2021 at 7:12 AM Leng Burgess <lkaing_at_gmail.com> wrote:

> 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
>
> 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*
>>
>
>

-- 
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