Re: ORA-1652 no matter how big temp tablespace made

While the configuration may be the same, in most development/production environments I've seen, the data in both systems are not the same. Are you trying to sort more rows? This can cause more sort space to be needed.

HTH,
Brian

Shirley Taylor wrote:
>
> Hi,
> We have a query which runs on our development instance using a total
> of 512M of temp tablespace. On the production instance it fills a 6gig
> temporary tablespace and fails. Database parameters are identical.
> Tablespaces are temporary not permanent. I used dbms_stats on the
> production server and exported the stats to the development server
> where I imported them but the query still runs properly and only uses
> 512M of sort space in temp. I've sent a mass of stuff to Oracle
> support but haven't heard back yet. Anyone experience this before?
> Thanks,
> Shirley

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"