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

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

Something is not the same: You just don't know what it is.

Post the query and the EXPLAIN PLAN.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)