How do you calcuate the temp space needed for view?

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Thu, 20 Feb 2003 17:08:49 -0800
Message-ID: <F001.00553C51.20030220170849@fatcity.com>

Hi Gurus,

I issue the following command select count(*) from view1 and encounter the following error "ORA-01630: max # extents (121) reached in temp segment in tablespace TEMP". I think I need to increase the tablespace TEMP but how do I calculate the temporary space needed ?

Assuming view1 is "select * from table1, table2 where table1.Col1=table2.Col1" Is the temporary space needed = (table 1 row-length * table 1 total number of rows ) * (table 2 row-length * table 2 total number of rows ) ?

Any advice ? Thanks.

Regds,
New Bee
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

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). Received on Thu Feb 20 2003 - 19:08:49 CST