RE: Anybody get a 1630 error when trying to add an index ?
Everybody ... thanks for your help on this. What happened is that I had increased the extents from 121 to 500, but because there was an existing session that had the object I had to wait for that session to end before the 500 extents were noticed. So, I did everything right, I just had to wait. Thanks for all you time on this. Peace ! Mike T -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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).
Re: Anybody get a 1630 error when trying to add an index ?
Check for both tablespaces maxextents 1) target tablespace and 2) temp tablespace. It appears that block_size of your database is 2K thus default maxextents are 121. You can alter both tablespaces like alter tablespace tablespace_name default storage(maxextents unlimited); Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Mon, 13 May 2002 11:33:21 -0800 I have been trying to add an index to a index tablespace and I keep getting a 1630 error. I have 500 extents , but it says the max extents are only 121 and they are filling up. Maybe my dendrites have been temporarily fried and it is something simple. Thanks for your time in advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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). MOHAMMAD RAFIQ _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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).
RE: Anybody get a 1630 error when trying to add an index ?
Mike, 1630 indicates "max # extents (%s) reached in temp segment in tablespace %s". It is probable that the INITIAL/NEXT is set low for your TEMP tablespace and the sorts/temp usage during index creation is bombing out on the upper limit? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life is here: http://www.gospelcom.net ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -Original Message- > From: Johnson, Michael [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 13, 2002 12:33 PM > To: Multiple recipients of list ORACLE-L > Subject: Anybody get a 1630 error when trying to add an index ? > > > I have been trying to add an index > to a index tablespace and I keep > getting a 1630 error. > > > I have 500 extents , but it says the > max extents are only 121 and they > are filling up. > > > Maybe my dendrites have been temporarily > fried and it is something simple. > > Thanks for your time in advance. > > Mike > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Johnson, Michael > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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).
RE: Anybody get a 1630 error when trying to add an index ?
Title: RE: Anybody get a 1630 error when trying to add an index ? Mike, Does you index creation script have a storage clause? It should look something like below. CREATE INDEX FLIGHT_LEGS_NDX1 ON FLIGHT_LEGS(D_ACTUAL_TIME, EVENT_TYPE) TABLESPACE ASIFNDX PCTFREE 10 STORAGE(INITIAL 160K NEXT 160K PCTINCREASE 0 MAXEXTENTS 500); Depending on the projected size of the index, you may need to change the Initial and Next to something like 5M. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Johnson, Michael [SMTP:[EMAIL PROTECTED]] I have been trying to add an index to a index tablespace and I keep getting a 1630 error. I have 500 extents , but it says the max extents are only 121 and they are filling up. Maybe my dendrites have been temporarily fried and it is something simple. Thanks for your time in advance. Mike
RE: Anybody get a 1630 error when trying to add an index ?
Have you checked the amount of max extents in the tablespace? The error you listed is saying that it is running out of extents in dealing with temporary objects created in the tablespace being used. Bryan -Original Message- Sent: Monday, May 13, 2002 3:33 PM To: Multiple recipients of list ORACLE-L I have been trying to add an index to a index tablespace and I keep getting a 1630 error. I have 500 extents , but it says the max extents are only 121 and they are filling up. Maybe my dendrites have been temporarily fried and it is something simple. Thanks for your time in advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan 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).
