moving LOBSEGMENT, LOBINDEX into another tablespace

[gxangel]

Hi,

Presently, i intend to move some tables from tablespace A to tablespace B. However, i found that in tablespace A, there are objects with type LobIndex and LobSegment. In this case, will it cause any problems to move the tables using the ALTER TABLE ... MOVE command?

Thanks alot!!!

[PAVB]

Statement below will move table to new tablespace BUT will not move LOB segments from current tablespace...

ALTER TABLE table_name MOVE TABLESPACE target_tablespace
/


Statement below will move segments that make up specific LOB column to new tablespace...

ALTER TABLE table_name
MOVE LOB(clob_column) STORE AS (
TABLESPACE target_tablespace
)
/


Cheers!

[gxangel]

Hi PAVB,

Hmm... i don't quite understand the part about

ALTER TABLE table_name
MOVE LOB(clob_column) STORE AS (
TABLESPACE target_tablespace
)

If the objects with type LobIndex and LobSegment are named 'SYS1234' with columns 'AA', 'BB', 'CC', does that mean that i have to specify all the columns names e.g. 'AA', 'BB', 'CC' in place of clob_column?

Does this syntax works for both LobIndex and LobSegment types????

Thanks so much!!!