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@xxxxxxxxx> 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@xxxxxxxxx
<mailto:mcdonald.connor@xxxxxxxxx>> wrote:
alter table MYTABLE move online
You're done :-)
On Tue, Jul 6, 2021 at 7:39 AM Leng Burgess <lkaing@xxxxxxxxx
<mailto: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
<mailto:dmarc-noreply@xxxxxxxxxxxxx>> 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 <http://connormcdonald.wordpress.com/>
twitter: @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