RE: Imaginary indexes created when setting CLOBs to null?

Jay - Yes, the index name means that Oracle created it. Did you create any primary keys or constraints? You can poke aroung the dictionary tables
(user_constraints, user_ind_columns) to find out something about it.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: JayMiller_at_TDWaterhouse.com [mailto:JayMiller_at_TDWaterhouse.com] Sent: Wednesday, March 19, 2003 3:36 PM
To: Multiple recipients of list ORACLE-L Subject: Imaginary indexes created when setting CLOBs to null?

We've been testing a new application in development using CLOBS. The developer contacted me with following error:  

1]: (Error): ORA-01654: unable to extend index YURIY.SYS_IL0000185466C00023$$ by 256 in tablespace TS_EMAIL_CLOB  

The odd things here are that  

1. It occurred while updating the CLOB column to null (why would setting something to null *increase* the size of an index?)
2. The named index does not exist (implying it was something Oracle might have created on the fly?)

I increased the tablespace size and the problem went away but I'm trying to figure out what happened.  

The tablespace is one assigned to the CLOB segment. Oracle 8.1.7.2
Solaris 2.6  

Thanks,
Jay Miller
x48355    

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

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).