RE: Solaris/8.1.7/LOBSEGMENT

Thanks! I found a note on MetaLink, and got your message at about the same time. I figured it out, and applied the change.  

Cheers,
Mike

-----Original Message-----
Sent: Monday, March 31, 2003 10:25 AM
To: 'ORACLE-L_at_fatcity.com'
Cc: Vergara, Michael (TEM)

> -----Original Message-----
> From: Vergara, Michael (TEM) [ mailto:mvergara_at_guidant.com]
>
> 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.

alter table owner.table_name modify lob (lob_name) (storage (maxextents N)) ;

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vergara, Michael (TEM)
  INET: mvergara_at_guidant.com

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: ListGuru_at_fatcity.com (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).