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. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, March 19, 2003 3:36 PM To: Multiple recipients of list ORACLE-L 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 a) It occurred while updating the CLOB column to null (why would setting something to null *increase* the size of an index?) b) 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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).
