Re: Altering lobsegment storage parameters

Check the ALTER TABLE command:
The command will be roughly:

alter table T1 modify lob (MYLOB) (storage (maxextents 100));

to get the index too it will be something like:

alter table T1 modify lob (MYLOB) (

        storage (maxextents 100));
        index (storage (maxextents 100))

I checked the first one on 8.1, but since you are using 8.0 I can't guarantee that I don't have the odd redundant pair of indices

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Craig Duncan wrote in message <37E8354E.42273A2F_at_mindspring.com>...
>I can't figure out how to alter that parameter. When I created the lob
>column I
>specified a separate tablespace for the lob data and lob index. I see
>that Oracle
>supplied a segment name in the specified tablespace for the lobsegment.
>
>DBA_SEGMENTS says this segment ("SYS_LOB0000006511C00002$") is a
>lobsegment.
>
>DBA_OBJECTS says the OBJECT_TYPE is "UNDEFINED".
>
>Anyway, I am unable to find the correct "alter" statement to extent this
>parameter.
>
>Preciate any help...
>
>Craig Duncan
>
Received on Wed Sep 22 1999 - 02:55:30 CDT