Exactly. However, less than 24 hours ago these queries (dynamically generated by the application) were working fine and our TEMP space looked healthy. So I did what you suggested; now TEMP is 4GB larger than it used to be, and I'm still running into the same error. I'm watching the TEMP space fill up and the query structure is not new and isn't retrieving that many rows.
I'm thinking that it has to do with the AIX upgrade for starters and I feel that it has something to do with SORTING but I have no evidence yet. Thanks anyway. Saira PS> I am learning the DBA role - not an expert by any means. --- Ganesh Raja <[EMAIL PROTECTED]> wrote: > From the docs... > > ORA-01652 unable to extend temp segment by string in > tablespace string > > Cause: Failed to allocate an extent for temporary > segment in tablespace. > > Action: Use ALTER TABLESPACE ADD DATAFILE statement > to add one or more > files to the tablespace indicated. > > > So Check your Temp TBS. > > HTH > > > Regards, > Ganesh R > HP : (+65)9067-8474 > Mail : [EMAIL PROTECTED] > > > ========================================== > All Opinions expressed are my own and do > not in anyway reflect those of my employer > ========================================== > > > -----Original Message----- > Saira Somani > Sent: Sunday, July 27, 2003 12:39 PM > To: Multiple recipients of list ORACLE-L > > > Hi Gurus, > > After upgrading the OS from AIX 4.3.3 to 5.1, our > Oracle 8i instance is dishing out plenty of ORA-1652 > which means that our application cannot commit any > transactions (or so I am finding in my tests). > > Help. The warehouse needs to be in production > tomorrow 8AM! > > Thanks, > Saira > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Saira Somani > 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: Ganesh Raja > 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: Saira Somani 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).
