I just tried a cartesian product/sort and the TEMP tablespace, which is set up as temporary and using a tempfile was able to autoextend. Of course, the next step is to set up a TEMP tablespace as temporary using a datafile, then permanent and see what happens...volunteers?
In regards to the issue of not autoextending in the event of a statement failure. If this were the case, then almost no autoextension would occur. If I insert 10 million rows into a table, causing the datafile to autoextend, I could issue a rollback and not 'save' the rows. However, the table would still have allocated the additional space (and the HWM would be WAY out there...). Dan Fink -----Original Message----- Sent: Thursday, November 07, 2002 2:44 PM To: Multiple recipients of list ORACLE-L 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: Fink, Dan 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).
