Moving LOBIndex and LOBSegment on a Partitioned Table - 10g
Hello -
I am trying to move the lobsegement and lobindex from the USERS table space to another table space on a partitioned table in Oracle 10g.
When I try using the following command:
ALTER TABLE aw$test_table
MOVE LOB(awlob) STORE AS (
TABLESPACE NEWTBSPACE
)
I get an error - SQL Error: ORA-14511: cannot perform operation on a partitioned object
I have also tried using the move partition clause:
ALTER TABLE aw$test_table MOVE PARTITION PTNN
TABLESPACE NEWTBLSPACE
LOB (awlob) STORE AS (TABLESPACE users);
And also get an error ORA-14257: cannot move partition other than a Range or Hash partition
I'd be grateful for any help anyone has on how I can move the lobindex and lobsegment from the users tablespace - thank you!