alter table table_name
modify lob (lob_column)
(storage (maxextents unlimited));
Look in dba_lobs if you are unsure of the table_name
the lobsegment belongs to.
Rob Pegram
Oracle Certified DBA
--- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]>
wrote:
> Hi all!
>
> I'm getting a report that a LOBSEGMENT has reached
> MAXEXTENTS.
> How do I modify this? ALTER LOBSEGMENT doesn't
> work. I'm still
> R'ing the FMs, but I thought I'd ask the list too.
>
> Thanks,
> Mike
>
> ---
>
===========================================================================
> Michael P. Vergara
> Oracle DBA
> Guidant Corporation
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Vergara, Michael (TEM)
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Pegram
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
