Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Move LOB index to a diff.tbs

Re: Move LOB index to a diff.tbs

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Tue, 21 Sep 2004 22:43:48 -0700
Message-Id: <1095831828.24300.204885426@webmail.messagingengine.com>


OOPS missed out mentioning something :

It should read --> lob(column_name) store as .. ; The word 'data' is misleading.

On Tue, 21 Sep 2004 22:40:17 -0700, "GovindanK" <gkatteri_at_fastmail.fm> said:
> This suggestion worked.
>
> Thanks
>
> Govindan
>
> On Tue, 21 Sep 2004 11:54:15 -0700, "Jamie Kinney"
> <OracleDude_at_gmail.com> said:
>
> >
> > alter table lob_test move tablespace RMAN
> > lob (data) store as
> > ( tablespace lob_indexes
> > index (tablespace lobs));
> >
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 22 2004 - 00:39:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US