RE: How to increase maxextents of LOBSEGMENT?

[Edward Shevtsov]

Title: Сообщение

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-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jonny Delmont
Sent: Monday, August 26, 2002 3:48 PM
To: Multiple recipients of list ORACLE-L
Subject: How to increase maxextents of LOBSEGMENT?

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

 

---

Get a bigger mailbox -- choose a size that fits your needs.

http://uk.docs.yahoo.com/mail_storage.html