Somewhat related. I recently heard about this parameter. It's only been
around for 4+ years. Sigh.
But a nice way to prevent unlicensed usage of Diagnostics & Tuning. Of course,
Oracle defaults to letting you use them....
EE only.
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/CONTROL_MANAGEMENT_PACK_ACCESS.html#GUID-A5CA11BA-AE1F-4A2E-9C59-A98BA1F4E5C2
-joe
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Rich J
Sent: Wednesday, July 7, 2021 7:05 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Online Table Reorg
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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.oracle.com%2Fen%2Fdatabase%2Foracle%2Foracle-database%2F19%2Fdblic%2FLicensing-Information.htm&data=04%7C01%7CJSweetser%40icat.com%7Cf6fe35598f294265216108d94148b4b7%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C1%7C637612602817533626%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=fXBL9RKyaecgTT315NbR%2F5Sy2UOUdmfombGkYRfVEUk%3D&reserved=0>
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<https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fconnormcdonald.wordpress.com%2F&data=04%7C01%7CJSweetser%40icat.com%7Cf6fe35598f294265216108d94148b4b7%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C1%7C637612602817543616%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=PW55GS2HeH6GS6%2FAJQirFdQyBan9MyBpNHU7Qdfyyps%3D&reserved=0>
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
This e-mail transmission and any attachments that accompany it may contain
information that is privileged, confidential or otherwise exempt from
disclosure under applicable law and is intended solely for the use of the
individual's to whom it was intended to be addressed. If you have received this
e-mail by mistake, or you are not the intended recipient, any disclosure,
dissemination, distribution, copying or other use or retention of this
communication or its substance is prohibited. If you have received this
communication in error, please immediately reply to the author via e-mail that
you received this message by mistake and also permanently delete the original
and all copies of this e-mail and any attachments from your computer. Please
note that coverage cannot be bound or altered by sending an email. You must
receive written confirmation from a representative of our firm to put coverage
in force or make changes to an existing policy.
