Oracle Database Discussions

Hi all,

I'm working with a 10.2.0.3 oracle version. I need to move some tables from tablespace A to a new tablespace B. I've a clear idea about how to move the "simple" tables:

ALTER TABLE table MOVE TABLESPACE B;

but I've some partitioned tables and another with lob columns, and my question is about how to move it.

For partitioned tables (without lob segments) I want do this:

ALTER TABLE table MOVE PARTITION partition_name TABLESPACE B;

And for the table with lob segments:

ALTER TABLE table MOVE LOB (lob_column) STORE AS (TABLESPACE B);

My question is, if with these kind of "special" tables, I need to do an "ALTER TABLE table MOVE TABLESPACE B;" or not and with the "MOVE PARTITION" and "MOVE LOB" is enough.

Best regards,
Jordi Ullate