Re: Move a LOB column to another tablespace

"Gary Streeter" <gstreeter_at_NOUCE.id-bs.com> wrote in message news:<BC569.467$jb4.50743_at_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!

use the ALTER TABLE ... MOVE LOB command

Jeff Weiss
Oracle Performance Tools for Senior DBA's http://www.confio.com Received on Tue Aug 13 2002 - 11:34:19 CDT