Maybe the UNION is trying to resolve duplicates that it doesn't have to??? i.e. requiring a sort
Have you tried UNION ALL Cheers Jeff Herrick On Sat, 30 Nov 2002, Lisa R. Clary wrote: > I have 3 individual views (average #records=76,000) with the exact same variable >names and datatypes. There is another view that is the union of the 3 individual >views. If I use a count(*) operation (in sqlplus) on the view that is the union (or >the individual view), I run out of temp space e.g. ORA-01652: unable to extend temp >segment by 256 in tablespace TEMP (108M temp space, ). If I do subsets, selects, >whatever, the views are fairly quick with no problems-- I just can't perform count(*) >operations > > Any ideas as to parameters in environment/temp space that would eliminate the extent >problem relative to the count function? > > thanks, > lc > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick 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).