Re: Relocating LOB segment

From: Kevin Jernigan <kevin.jernigan_at_oracle.com>
Date: Fri, 06 Feb 2015 15:15:38 -0800
Message-ID: <54D54B1A.5000409_at_oracle.com>

If / when you upgrade to 12.1 (Oracle Database 12c), more parallelism on SecureFiles LOBs is supported. Also, you can use the (new in 12c) "ONLINE" keyword with the "ALTER TABLE MOVE" statement to move and/or compress and/or convert data while the table remains fully online...KJ

-- 
Kevin Jernigan
Senior Director Product Management
Advanced Compression, Hybrid Columnar
Compression (HCC), Database File System
(DBFS), SecureFiles, Database Smart Flash
Cache, Total Recall, Database Resource
Manager (DBRM), Direct NFS Client (dNFS),
Continuous Query Notification (CQN),
Index Organized Tables (IOT), Information
Lifecycle Management (ILM)
+1-650-607-0392 (o)
+1-415-710-8828 (m)

On 2/6/15 3:48 AM, Hameed, Amir wrote:


>

> Thanks Brent. The DB version is 11.2.0.4.

>

> *From:*Brent Day [mailto:coloradodba_at_gmail.com]

> *Sent:* Thursday, February 05, 2015 10:49 PM

> *To:* Hameed, Amir

> *Cc:* oracle-l_at_freelists.org

> *Subject:* Re: Relocating LOB segment

>

> Sorry I hit send to soon.

>

> Without knowing your version it is hard to give you correct 

> information but I will give you a couple of thoughts that might help 

> based on tools and methods I have used.

>

> If you are on 11.2 and use SecureFiles then you can export with 

> parallel. I have used this a few times but it does require the lob to 

> already be stored as secure files. See metalink doc 1467662.1 for 

> details.

>

> Another alternative is to use DBMS_REDEFINITION. If you haven't used 

> this tool before it is awesome. You can move the table behind the 

> scenes while allowing transactions to continue (captured via 

> materialize views behind the scene). Once the initial table create and 

> data load is done you can sync the changes, then build your indexes, 

> keys, etc. and then run the finalize procedure.

>

> Hope that helps.

>

> Brent

>

> On Thu, Feb 5, 2015 at 8:34 PM, Brent Day <coloradodba_at_gmail.com 

> <mailto:coloradodba_at_gmail.com>> wrote:

>

>     Since it is a LOB you can't parallelize it.

>

>     http://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel001.htm#CACGFHCC

>

>     You can typically use parallel DDL where you use regular DDL.

>     There are, however, some additional details to consider when

>     designing your database. One important restriction is that

>     parallel DDL cannot be used on tables with object or |*LOB*| columns.

>



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

Received on Sat Feb 07 2015 - 00:15:38 CET