Re: Move a LOB column to another tablespace

From: Gary Streeter <gstreeter_at_NOUCE.id-bs.com>
Date: Tue, 13 Aug 2002 11:57:36 +0100
Message-ID: <BC569.467$jb4.50743@newsfep1-win.server.ntli.net>

Anotonios,

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!

You need to use the ALTER TABLE command with the LOB clause:

ALTER TABLE constants MOVE LOB (lob_column_name) STORE AS (TABLESPACE USERS)

Gary

"Antonios Christofides" <A.Christofides_at_itia.ntua.gr> wrote in message news:slrnalho94.o8j.A.Christofides_at_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:57:36 CDT