How can we rebuild (or reorg ?) @@@only one partition@@@@ without disturbing our 24*7 service....

 hi...

1
###############################################
we are using 9208-64bit sun 10.

we reorg (or rebuild), only one partition... (during service down)

example> Table : PART partition : PART1 (PART1~PART12)

alter table SCOTT.PART move partition PART1 tablespace PARTTEMP ;
alter table SCOTT.PART move partition PART1 tablespace PARTTBS ;

-- index rebuild

2
###############################################
we want to reorg(or rebuild), only one partition during service time...
(do not distrubing service)

so,

1>
'dbms_redefinition'
but, this is useful when reorg entire Table (not for only one partition).

2>
use """online"" but we got ORA-14020.

alter table SCOTT.PART move partition PART1 tablespace PARTTEMP online;
<-- ORA-14020: this physical attribute may not be specified for a table partition