Help -- to modify the storage parameter for LOBSEGMENT

From: Chuan Zhang <chuan_at_asiaonline.net>
Date: Wed, 31 Jan 2001 20:40:52 -0800
Message-ID: <F001.002A6C37.20010131194523@fatcity.com>

Hi, DBA gurus,
 
 
  I have got this problem.
 

When I issue the following query,
 

select segment_name<FONT
color=#0000f0 size=2>,
segment_type,<FONT color=#000000
size=2>tablespace_name,<FONT

color=#000000 size=2>extents,<FONT 
color=#000000 size=2> max_extents,<FONT 
color=#000000 size=2> next_extent/<FONT 
color=#800000 size=2>1024 <FONT 
color=#0000f0 size=2>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
 
 
 
 
Received on Wed Jan 31 2001 - 22:40:52 CST