Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: "unable to extend segment" error and remote queries
You have run out of room in your TEMP (sort area) tablespace. You should
look to see how big it is and either 1) add a datafile to expand the space
available to sort with and/or 2) defrag the tablespace to make the free
space more accessible then 3) resize the initial, next, and pctincrease
parameters to make better use of the available area.
Josh Gough <dasjsg_at_panther.gsu.edu> wrote in article
<367EA726.84E3BA41_at_panther.gsu.edu>...
> After looking at the alert log again, i see it has more information than
> the error message from Sql Plus,
> it says "by 128 .... tablespace TEMP" so I guess I need to extend the
TEMP
> space
>
>
> > error:
> > ERROR at line 3:
> > ORA-01652: unable to extend temp segment by in tablespace
> > ORA-02063: preceding line from FAUD
>
>
Received on Tue Dec 22 1998 - 08:43:52 CST