Re: tablespace

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

You need to edit the init.ora file MAX_EXTENTS = line. Take down the database, then bring it up again.

Good Luck
Randy

--
   ..uu.                   z'                 ,   ___________________
  ?$""`?i      .          x"                .uu   I     Randy       I
  `M  ._at_"     d9b    .    f   .,.uun.  ?$   ?i'   I   DeWoolfson    I
  'Z :#"     M `8   U8   <   .dP"```"# `M  ._at_"    I-----------------I
  '&H?`     X ,oR   $5.  $   ?*     _at_  'Z :#"     I randyd_at_cais.com I
  d#`*L    :RP' $b  f`$L:M   Xf   .f'  '&H?`      I-----------------I
,!">  5.   $'   ?X  X  "NXF  M  .=`    d#`        I     ,\\/.       I
   >  'M  d$    `E  M   "$$  Mux~    n!"          I     |o o|       I
   k   `h '     '  ""    `   z"     *             I=ooO==(_)==Ooo===I
   %     `                  "      "              I_________________I