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
Title: 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-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003
10
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. Verga