Re: Help -- to modify the storage parameter for LOBSEGMENT

You wrote:

Hi, DBA gurus,

  I have got this problem.

When I issue the following query,

select segment_name, segment_type,tablespace_name,extents, max_extents, next_extent/1024 from user_segments

I got one row like the following:

segment_name: SYS_LOB0000080843C00004$$

segment_type: LOBSEGMENT.

I have checked that it is not a table or index. I have no idea how it is created. More emergent for me is that I don't know how to modify the storage parameters for this lobsegment.

Can anyone help me? Thanks very much in advance.

Now the DB is running on Solaris 2.7, Oracle EE 8.1.5.

Chuan Zhang

Here is my answer:

1.First find out the segment type( table or index) of the lobsegment by querying dba_lobs table.
 2.Then you need to find our which column in this segment use lob datatype. 3. Then you use following syntax to modify storage parameter for this particular column:

alter table/index {table/index}_name
modify lob (column_name)
(storage (maxextents * pctincrease * ....))

Hope this help.

Eveleen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: exu_at_nnng.com

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).