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

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Wed, 31 Jan 2001 23:19:26 -0800
Message-ID: <F001.002A6CC0.20010131204527@fatcity.com>

Chuan,  

This is a large object segment.  

select table_name from dba_lobs where segment_name = 'SYS_LOB0000080843C00004$$'
/  

This should give you the table to which this LOB belongs. If you do not need it you can drop the table.  

If you need to alter the storage parameter look at initial_extent,next_extent from user_segments.  

You would need to export the table.
Drop the table, recreate it with new storage values Import the table  

HTH
Suhen  

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        

--

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

Author: Suhen Pather
  INET: Suhen.Pather_at_strandbags.com.au

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). Received on Thu Feb 01 2001 - 01:19:26 CST