RE: How to increase maxextents of LOBSEGMENT?

Hi Jonny,  

try this:  

select table_name, column_name from dba_lobs where segment_name = 'SYS_LOB0000022841C00003$$'  

alter table your_table_name modify
  lob (column_name)
(storage (maxextents 500));
 

Regards,
Ed

-----Original Message-----
Delmont
Sent: Monday, August 26, 2002 3:48 PM
To: Multiple recipients of list ORACLE-L

Dear list,

How to increase maxextents of LOBSEGMENT?

SQL> alter LOBSEGMENT TRST.SYS_LOB0000022841C00003$$ storage (maxextents 1022);
alter LOBSEGMENT TRST.SYS_LOB0000022841C00003$$ storage (maxextents 1022)

      *
ERROR at line 1:
ORA-00940: invalid ALTER command

TIA, Jonny  

<http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_st orage.html> Get a bigger mailbox -- choose a size that fits your needs.  

<http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_st orage.html> http://uk.docs.yahoo.com/mail_storage.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Edward Shevtsov
  INET: eshevtsov_at_detmir.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).