Re: tablespace

Obviously there is something missing from the statement you show. You must have been doing an "order by" or a "group by" or something else that requires a temporary segment which is not shown. Basically you need to monitor sys.dba_segments for type 'TEMPORARY' to see how your temporary segments are being utilized and what will be optimal initial and next extent for your temporary tablespace. Your current settings for initial and next are to small.

Mike Huneycutt
mah_at_sequent.com

Madhavi Lokam (gmadhavi_at_pms991.pms.ford.com) wrote:
: In article <3ontap$7ie_at_senator-bedfellow.MIT.EDU>, jkhuon_at_athena.mit.edu (Jenny Khuon) writes:
: |>
: |> --
: |>
: |> Does anyone know how to solve the problem as below:
: |>
: |> SQL> select emp_no, ename from ogb.employee;
: |> ERROR:
: |> ORA-01630: max # extents (121) reached in temp segment in tablespace TEMP
: |>
: |> no rows selected
: |>
 

: Your temp segment is not enough. Increase its size.
 

: Madhavi Lokam
: consultant
Received on Mon May 15 1995 - 00:00:00 CEST