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@xxxxxxxxx>
wrote:
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.
--
Connor McDonald
===========================
blog: 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*
