Moving a partition online– alter table move or dbms_redef?

  Moving a partition online– alter table move or dbms_redef?

 

 

I have a large partitioned table (by date) that data is activity loaded into. The data that is getting loaded is going into the newest partitions.

 

I have local indexes on the table.

 

I have to move several of the older partitions ( no dml against these partitions) into a different tablespace.

 

Now I know I can run the following:

 

alter table ELEMENT move partition ID0156 PARALLEL (DEGREE 4)

tablespace CF_20090409 nologging

 

alter index ELEMENT_PK rebuild partition ID0156 online PARALLEL (DEGREE 2)

tablespace CF_IDX_20090409 nologging

 

My questions are”

 

Will this create a lock on the entire table or just the partition getting moved?