as i said. maybe temp segments don't cause autoextend :) --- Ron Rogers <[EMAIL PROTECTED]> wrote: > Let's think about this for a minute. > You create and index called idx1 using a designated tablespace that > has > sufficient space to hold the complete index. > You create a new index idx2 on the table using the same tablespace > and > you think that it should autoextend to hold the permanent index. > The system generates the index and starts placing the temporary > index > named something like 123.123 in the tablespace. This index is a > temporary index until the system has completed creating the entire > index. Then it will make the index name permanent as idx2 and use the > space accordingly with the required extents and autoextend. Oracle > does > not know that the index will complete, be aborted, crash, etc so it > can > not make any permanent assignment to the extents( that is why it is > called temporary) . Oracle would permanently extent tablespaces for > each > temporary function then the database could artificially expand when > the > functions were only temporary in nature and the compounded effect > could > cause a ripple effect. The backup size would expand, search functions > could take longer because of the increased size, disk space would be > wasted. > Just a few thoughts and ideas. > Ron > > >>> [EMAIL PROTECTED] 11/07/02 04:43PM >>> > maybe temp segments don't cause an autoextend? > > at least it's consistent > > --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > > Update... I tried the same test with 8.1.7 on Solaris 8. Same > > result... > > > > -----Original Message----- > > Sent: Thursday, November 07, 2002 1:09 PM > > To: Multiple recipients of list ORACLE-L > > > > > > I just manually expanded the file and the index build finished with > > no > > problem. I also set the USER_DATA ts as autoextend and it extended > > several > > times without error. The only difference is in the fact that the > > INDEX > > segment is initially created as a TEMP segment. Interesting.... > > > > -----Original Message----- > > Sent: Thursday, November 07, 2002 10:34 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Dan, > > That's exactly, what someone described yesterday, it was LMT with > > autoallocate, and they made sure, that there was plenty of space on > > the hard > > drive for TEMP file to grow. > > The only difference: it was not Solaris - it was AIX. > > > > Igor Neyman, OCP DBA > > [EMAIL PROTECTED] <mailto:ineyman@;perceptron.com> > > > > > > > > > > ----- Original Message ----- > > To: Multiple recipients of list <mailto:ORACLE-L@;fatcity.com> > > ORACLE-L > > Sent: Thursday, November 07, 2002 12:15 PM > > > > Igor and Yechiel, > > Thanks for the responses. I'm glad to hear that I am not the > only > > one > > experiencing the problem. > > I should have also mentioned that the tablespace is LMT with > > autoallocate and is nowhere near the max size. > > > > Dan Fink > > > > -----Original Message----- > > Sent: Thursday, November 07, 2002 9:35 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi Paulo > > > > When creating an index, or CTAS, oracle use temp segments while > > building and > > rename them after the build finish. So if you do not have enough > > space you > > will get: unable to allocate TEMP segment. > > > > Yechiel Adar > > Mehish > > > > ----- Original Message ----- > > To: Multiple recipients of list <mailto:ORACLE-L@;fatcity.com> > > ORACLE-L > > Sent: Thursday, November 07, 2002 6:04 PM > > > > never heard on this problem but are u sure table the temp > tablespace > > of the > > user executing the commeand is temp and not user_indx??? > > regards > > Paulo > > > > -----Original Message----- > > Sent: quinta-feira, 7 de Novembro de 2002 15:39 > > To: Multiple recipients of list ORACLE-L > > > > > > I have a 9.2 database running on Solaris 8. I'm creating some test > > tables > > with indexes. The USER_INDX tablespace's datafile is set to > > autoextend (as > > are TEMP and USER_DATA). When the system attempts to create > indexes, > > instead > > of auotextending the datafile (there is plenty of space on the > > device), it > > throws an ORA-01652: unable to extend temp segment by 128 in > > tablespace > > USER_INDX error. If I manually resize the datafile and rerun it, no > > problems. > > > > Anyone else heard of this behavior? I can't find anything on > Metalink > > that > > fits the problem definition. > > > > Dan Fink > > > > > > > __________________________________________________ > Do you Yahoo!? > U2 on LAUNCH - Exclusive greatest hits videos > http://launch.yahoo.com/u2 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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.com > -- > Author: Ron Rogers > 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).
__________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).