Re: Move a LOB column to another tablespace

From: Antonios Christofides <A.Christofides_at_itia.ntua.gr>
Date: Tue, 13 Aug 2002 11:59:47 +0000 (UTC)
Message-ID: <slrnalht5k.tp1.A.Christofides@acheloos.itia.civil.ntua.gr>

Gary Streeter wrote:
> The command required is not easy to deduce from the Oracle manuals
> and there are limited examples so it's not surprising that you are
> having problems!

Thanks! The problem is that this syntax appears under "move_table_clause". Another problem with the HTML manuals is that the syntax diagrams are bitmaps, so you can't search them. Otherwise, a search for "LOB" (which I did) would also have solved the problem.

> You need to use the ALTER TABLE command with the LOB clause:
>
> ALTER TABLE constants MOVE LOB (lob_column_name) STORE AS
> (TABLESPACE USERS)
Received on Tue Aug 13 2002 - 06:59:47 CDT