MIME-Version: 1.0
References: <BYAPR06MB493458263FF22AA9EB64218FF70E9@BYAPR06MB4934.namprd06.prod.outlook.com>
 <8B935980-D7CE-4E77-81FA-66B7340507B8@gmail.com> <CAB=aETCdP3oKczF+O5LvqS1aPWomB=6JuC5RwFPWA66Q7d-w-w@mail.gmail.com>
In-Reply-To: <CAB=aETCdP3oKczF+O5LvqS1aPWomB=6JuC5RwFPWA66Q7d-w-w@mail.gmail.com>
From: Rich J <rich242j@gmail.com>
Date: Wed, 7 Jul 2021 08:04:45 -0500
Message-ID: <CAANsBX1SvUvzwxQsO0D9LaJAhXeXrBi2Vu8eoCS6fL8+H2tUhQ@mail.gmail.com>
Subject: Re: Online Table Reorg
To: "oracle-l@freelists.org" <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="00000000000059a49005c6882f00"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: rich242j@gmail.com
--00000000000059a49005c6882f00
Content-Type: text/plain; charset="UTF-8"

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@gmail.com>
wrote:

> alter table MYTABLE move online
>
> You're done :-)
>
> On Tue, Jul 6, 2021 at 7:39 AM Leng Burgess <lkaing@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@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: @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*
>

--00000000000059a49005c6882f00
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Folks should be aware that the online move option is only =
usable if you have an EE license:<br><br><div><a href=3D"https://docs.oracl=
e.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.htm=
">https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licen=
sing-Information.htm</a></div><div><br></div><div>See feature &quot;Online =
table organization&quot;.</div><div><br></div><div>Rich<br></div></div><br>=
<div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Ju=
l 7, 2021 at 12:26 AM Connor McDonald &lt;<a href=3D"mailto:mcdonald.connor=
@gmail.com">mcdonald.connor@gmail.com</a>&gt; wrote:<br></div><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_d=
efault" style=3D"font-family:tahoma,sans-serif;font-size:small">alter table=
 MYTABLE move online</div><div class=3D"gmail_default" style=3D"font-family=
:tahoma,sans-serif;font-size:small"><br></div><div class=3D"gmail_default" =
style=3D"font-family:tahoma,sans-serif;font-size:small">You&#39;re done :-)=
</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_=
attr">On Tue, Jul 6, 2021 at 7:39 AM Leng Burgess &lt;<a href=3D"mailto:lka=
ing@gmail.com" target=3D"_blank">lkaing@gmail.com</a>&gt; wrote:<br></div><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><div><div>Hi Atul,</div><d=
iv><br></div><div>Here are some simple steps for basic tables:</div><div><b=
r></div>1) ALTER TABLE move=C2=A0<div>2) rebuild unusable indexes</div><div=
>3) recompile invalid objects</div><div><div><br></div><div>Non-basic table=
s like IOT, LOBS, partitioned tables will have to be done a little differen=
tly</div><div><br></div><div>Cheers,</div><div><br></div><div>Leng.</div><d=
iv><br><blockquote type=3D"cite"><div>On 18 Jun 2021, at 1:36 am, Atul Chou=
dhary (Redacted sender &quot;Atul.Choudhary&quot; for DMARC) &lt;<a href=3D=
"mailto:dmarc-noreply@freelists.org" target=3D"_blank">dmarc-noreply@freeli=
sts.org</a>&gt; wrote:</div><br><div><div style=3D"font-family:Helvetica;fo=
nt-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;=
letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;=
white-space:normal;word-spacing:0px;text-decoration:none"><div style=3D"mar=
gin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif;vertical=
-align:baseline"><span style=3D"font-size:12pt">Wanted to check if anyone h=
as tried online table reorg.=C2=A0=C2=A0 ? What are the steps ?=C2=A0 I was=
 looking for all steps.</span></div></div></div></blockquote></div><br></di=
v></div></blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=
=3D"ltr"><div dir=3D"ltr"><div>Connor McDonald<br>=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br>blog: =C2=A0 <=
a href=3D"http://connormcdonald.wordpress.com" target=3D"_blank">connormcdo=
nald.wordpress.com</a><br>twitter: @connor_mc_d<br><br><div>&quot;If you ar=
e not living on the edge, you are taking up too much room.&quot;=C2=A0</div=
><div>- Jayne Howard</div><div><br></div><div><i><font size=3D"1">Fine prin=
t: Views expressed here are my own and not necessarily that of my employer<=
/font></i></div></div></div></div>
</blockquote></div>

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