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 <gans_r_at_rediffmail.com> 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 : ganesh.raja_at_logicacmg.com
>
>
> ==========================================
> 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: saira_somani_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: gans_r_at_rediffmail.com
>
> 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: ListGuru_at_fatcity.com (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
Received on Sat Jul 26 2003 - 23:15:30 CDT