Hi....

Does anyone know how i can change the tablespace of a table that uses blobs. I want to change the tablespace for the LOB Storage but have so far been unsuccesful. I am using the following SQL statement:-

ALTER TABLE IMAGE MOVE TABLESPACE XSU001

But when i go and check the table the tablespace being used for the LOB_STAORAGE is the old one and the tablespace being used for the Table is XSU001. But ideally i would like the whole database in 1 tablespace.

Appreciate your help!!!! and thanks in advance