Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from smtp-aa.freelists.org (smtp-aa.freelists.org [23.23.80.81]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 61492100340606 for ; Wed, 7 Jul 2021 15:28:44 +0200 (CEST) Received: from turing.freelists.org (ip-10-0-0-164.ec2.internal [10.0.0.164]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (No client certificate requested) by smtp-aa.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id E4D73414C1; Wed, 7 Jul 2021 13:28:41 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id ACE1D3FFB0; Wed, 7 Jul 2021 13:28:33 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1625664513; bh=tVyGULQZVnG3uhAYNjur7SbDLTB+KttBllv7X/vWMWo=; h=From:Sender:Sender:From; b=Xix2IjCi+HX1XEQqcOL4S/Qzbq6NaY374e06ujt3z4vP9yOWoTl5/Niah5y9Iya2K dxmOtqTVWrxFOr3U0tMn3ipWr8hph3eoLsrXt9M8bL36a1hdmZ5OtLHHN4qMKyHh0a qJgCROteU/S4NKJteWWYIXuxp6mztyF2ajwAH94k= X-Virus-Scanned: by FreeLists at turing2.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id KxkSk7tFPMSt; Wed, 7 Jul 2021 13:28:33 +0000 (UTC) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id F3D503FF9B; Wed, 7 Jul 2021 13:28:30 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1625664512; bh=tVyGULQZVnG3uhAYNjur7SbDLTB+KttBllv7X/vWMWo=; h=From:Sender:Sender:From; b=m7iUKI4GW/XWrBMRqLEjeghWpKcxNBdOHqJPWS92DZFj0IOTatpzHNBpvrA2IsdRX v6/2ANG0OQdaz/4oWU6/eMTkzXmQoVuqN9wr+bw/l0iCHrwPcQZECzXkBykUkR0gYV KKvI/ad9KsUhJSr9Y3vs3S6LAve/ctoAqi7tGnUw= Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Jul 2021 13:28:29 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 8C2A93FF99 for ; Wed, 7 Jul 2021 13:28:29 +0000 (UTC) Authentication-Results: turing.freelists.org; dkim=pass (1024-bit key; unprotected) header.d=icatmanagers.onmicrosoft.com header.i=@icatmanagers.onmicrosoft.com header.a=rsa-sha256 header.s=selector2-icatmanagers-onmicrosoft-com header.b=IPSP3Wnk; dkim-atps=neutral Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 38Zl6EvGInSd for ; Wed, 7 Jul 2021 13:28:29 +0000 (UTC) Received: from NAM11-DM6-obe.outbound.protection.outlook.com (mail-dm6nam11on2100.outbound.protection.outlook.com [40.107.223.100]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Postfix) with ESMTPS id 4C1533FF98 for ; Wed, 7 Jul 2021 13:28:29 +0000 (UTC) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Q3eIVoooeg/6a1N416StGETh9VcDxeTde9q4ZIYkZg44cQ3x6gbaAn0dWXDAr791svhWEy7MNKmLkZs0hhzSNPewBwR53W+It/UZtBGbME9IJh6OTkwSvCvsWYOs7iMe18O2ZFzDsBtQNiiI3+TB+Ea0oouxV98tLuGZOTf/9mD7UcxaeCIrITvJIMXCYMA23I4r3zHUg0qWnTltHwSWaZBLx1U81cpDVqvuG6Yx3nW/4i1UtsZe+uYcMMUDzegQteK96jlNkPzjsb5DFgYucqLN04RiqXiDK2ZA5GBLCOyawk8LBJM1HFjlmMRNB4+fnqzz1C2yH6uuXSTfx31Xtw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Egjrf0bxSRoSSpXKIKOArkFtzslWdaK3dNBo2EC7b6E=; b=O6BQfGWY6mw8iJmwktJJf2LA2XVG+r9lJPILza602HuSAFRd9R9HXEKqChUDZM8Mli1iT/lCNxoMbahhu2MoEoiqBbGOsO3k0a+z7htF1pxCRbDYWHCua+MlHIN9Qt4jBNweDh6P+3qOE+3e7PpFiVR/8Hh+l3oAnKeYYzuxnXLARoNyPpHz4pnmMe84NBaDYuZkf0buUiDywGq95Aqg11L5Q+5thLsNF+C3ATEYRiDBnWRLOKBEzBDWFny2ZrA7aXcMpiHiA1ipuXF2EU2Wgh105HabcL1s9zuOIvXwK+8diG9twuasP8yhZiPBxFyM+ktA1qc65EmxZq1M8KfSAw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=icat.com; dmarc=pass action=none header.from=icat.com; dkim=pass header.d=icat.com; arc=none Received: from SN6PR11MB2720.namprd11.prod.outlook.com (2603:10b6:805:56::27) by SA2PR11MB5148.namprd11.prod.outlook.com (2603:10b6:806:11e::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4308.21; Wed, 7 Jul 2021 13:28:26 +0000 Received: from SN6PR11MB2720.namprd11.prod.outlook.com ([fe80::e8ed:7f33:7491:f9ea]) by SN6PR11MB2720.namprd11.prod.outlook.com ([fe80::e8ed:7f33:7491:f9ea%7]) with mapi id 15.20.4308.021; Wed, 7 Jul 2021 13:28:26 +0000 From: "Sweetser, Joe" To: "rich242j@gmail.com" , "oracle-l@freelists.org" Subject: RE: Online Table Reorg Thread-Topic: Online Table Reorg Date: Wed, 7 Jul 2021 13:28:26 +0000 Message-ID: References: <8B935980-D7CE-4E77-81FA-66B7340507B8@gmail.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=icat.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: f76e9d96-9b90-48c6-8ffe-08d9414b19f8 x-ms-traffictypediagnostic: SA2PR11MB5148: x-ms-oob-tlc-oobclassifiers: OLM:1850; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SN6PR11MB2720.namprd11.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(498600001)(83380400001)(55016002)(26005)(33656002)(71200400001)(166002)(966005)(53546011)(110136005)(2906002)(6506007)(7696005)(52536014)(8936002)(8676002)(38100700002)(5660300002)(86362001)(66476007)(7116003)(122000001)(186003)(66946007)(64756008)(66556008)(66446008)(3480700007)(9686003)(76116006);DIR:OUT;SFP:1102; x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_SN6PR11MB27209E58A0201F0A2B1A3B64D41A9SN6PR11MB2720namp_" MIME-Version: 1.0 X-OriginatorOrg: icat.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SN6PR11MB2720.namprd11.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: f76e9d96-9b90-48c6-8ffe-08d9414b19f8 X-MS-Exchange-CrossTenant-originalarrivaltime: 07 Jul 2021 13:28:26.2569 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 5d3bf30e-9adb-4c17-b242-5c17523e6e5e X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: bW0Je7M2udCDm6jPOOWGXWE5OCg0d98mOR6kdFpEGDtJQCeBElHrrwsBK/d9U4hXs5hLtuU/HgxTrR0ePk5SdQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: SA2PR11MB5148 X-archive-position: 80319 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: JSweetser@icat.com Precedence: normal Reply-To: JSweetser@icat.com List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-Subscribe: List-Owner: List-post: List-Archive: X-list: oracle-l --_000_SN6PR11MB27209E58A0201F0A2B1A3B64D41A9SN6PR11MB2720namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Somewhat related. I recently heard about this parameter. It's only been a= round for 4+ years. Sigh. But a nice way to prevent unlicensed usage of Diagnostics & Tuning. Of cou= rse, Oracle defaults to letting you use them.... EE only. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/CONTR= OL_MANAGEMENT_PACK_ACCESS.html#GUID-A5CA11BA-AE1F-4A2E-9C59-A98BA1F4E5C2 -joe From: oracle-l-bounce@freelists.org On Beha= lf Of Rich J Sent: Wednesday, July 7, 2021 7:05 AM To: oracle-l@freelists.org Subject: Re: Online Table Reorg Folks should be aware that the online move option is only usable if you hav= e an EE license: https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensi= ng-Information.htm See feature "Online table organization". Rich On Wed, Jul 7, 2021 at 12:26 AM Connor McDonald > wrote: alter table MYTABLE move online You're done :-) On Tue, Jul 6, 2021 at 7:39 AM Leng Burgess > 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) > wrote: Wanted to check if anyone has tried online table reorg. ? What are the st= eps ? I was looking for all steps. -- Connor McDonald =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 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 This e-mail transmission and any attachments that accompany it may contain = information that is privileged, confidential or otherwise exempt from discl= osure under applicable law and is intended solely for the use of the indivi= dual'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, di= ssemination, distribution, copying or other use or retention of this commun= ication or its substance is prohibited. If you have received this communica= tion in error, please immediately reply to the author via e-mail that you r= eceived this message by mistake and also permanently delete the original an= d 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 cove= rage in force or make changes to an existing policy. --_000_SN6PR11MB27209E58A0201F0A2B1A3B64D41A9SN6PR11MB2720namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Somewhat related.  I recently he= ard about this parameter.  It’s only been around for 4+ years.&n= bsp; Sigh.

 

But a nice way to prevent unlicensed = usage of Diagnostics & Tuning.  Of course, Oracle defaults to lett= ing you use them….

 

EE only.

 

https://docs.oracle.com/en/database/o= racle/oracle-database/12.2/refrn/CONTROL_MANAGEMENT_PACK_ACCESS.html#GUID-A= 5CA11BA-AE1F-4A2E-9C59-A98BA1F4E5C2

 

-joe

 

From: oracle-l-bounce@freelists.org = <oracle-l-bounce@freelists.org> On Behalf Of Rich J
Sent: Wednesday, July 7, 2021 7:05 AM
To: oracle-l@freelists.org
Subject: Re: Online Table Reorg

 

Folks should be aware= that the online move option is only usable if you have an EE license:=

 

See feature "Online table organization".

 

Rich

 

On Wed, Jul 7, 2021 at 12:26 AM Connor McDonald <= mcdonald.connor@gmail.com&= gt; 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 trie= d online table reorg.   ? What are the steps ?  I was lookin= g for all steps.

 


 

--

Connor McDonald
=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
blog:   connormcdonald.wordpress.com
twitter: @connor_mc_d

"If you are not living on the edge, you are tak= ing 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 discl= osure under applicable law and is intended solely for the use of the indivi= dual'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, copyin= g or other use or retention of this communication or its substance is prohi= bited. 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 o= riginal and all copies of this e-mail and any attachments from your compute= r. Please note that coverage cannot be bound or altered by sending an email. You must receive written confirma= tion from a representative of our firm to put coverage in force or make cha= nges to an existing policy. --_000_SN6PR11MB27209E58A0201F0A2B1A3B64D41A9SN6PR11MB2720namp_-- -- http://www.freelists.org/webpage/oracle-l