Hello,
I am trying to move a large LOB segment to another tablespace using following SQL
{code}alter table DBUSER.LOBTABLE move lob(LOBCOL) store as ( tablespace ABC) PARALLEL 10 ;{code}
and following is the plan (from the memory)
{code}
Plan hash value: 3748568941
--------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib |
--------------------------------------------------------------------------------------------------------------------
| 0 | CREATE TABLE STATEMENT | | | | 42841 (100)| | | | |
| 1 | LOAD AS SELECT | | | | | | | | |
| 2 | PX COORDINATOR | | | | | | | | |
| 3 | PX SEND QC (RANDOM) | :TQ10000 | 3665K| 478M| 42841 (1)| 00:07:52 | Q1,00 | P->S | QC (RAND) |
| 4 | PX BLOCK ITERATOR | | 3665K| 478M| 42841 (1)| 00:07:52 | Q1,00 | PCWC | |
|* 5 | TABLE ACCESS FULL | LOBTABLE | 3665K| 478M| 42841 (1)| 00:07:52 | Q1,00 | PCWP | |
--------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
5 - access(:Z>=:Z AND :Z<=:Z)
{code}
However, when I checked documentation (http://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel001.htm#CACGFHCC), it appears to suggest oracle can't use parallel DDL on tables with LOB columns.
So is my lob segment move (using above SQL) taking place in parallel or not?
Thanks in advance