Move a LOB column to another tablespace

From: Antonios Christofides <A.Christofides_at_itia.ntua.gr>
Date: Tue, 13 Aug 2002 10:36:19 +0000 (UTC)
Message-ID: <slrnalho94.o8j.A.Christofides@acheloos.itia.civil.ntua.gr>

Hi, I have Oracle 8.1.7. I had a table in the SYSTEM tablespace and moved it to the USERS tablespace with

ALTER TABLE constants
MOVE TABLESPACE USERS The table contains two CLOB columns, which remain in the SYSTEM tablespace. I've been reading the docs and searching Google Groups for over an hour with no results. I can't find an ALTER TABLE clause to move a LOB column to another tablespace.

Thanks! Received on Tue Aug 13 2002 - 05:36:19 CDT