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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
