Re: internal LOB - altering future extents

The tram-tracks for TABLE statements are so long now its getting really hard to work out what you need. The answer is something like:

alter table XXX modify lob (my_clob)
(storage (next 100M maxextents 110))
;

--

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

Jim Kennedy wrote in message ...
>I am getting an error on a CLOB in my table and the error is that segment
>foo.SYS-213456efew$ has reached maxextents 99. If this was on a table I
>would do
>
>alter table theTable storage(next 50m maxextents 250);
>
>for example. Do I just do the same for a CLOB in my table or do I have to
>alter the storage parameters on the clob itself and if so how do I do that
>(I tried alter segment foo.SYS-213456efew$ storage(.....) ) and it did not
>like that.
>
>Jim
>
>
>
Received on Mon Nov 08 1999 - 06:56:08 CST