Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA 1652
In addition to the other responses, if you have the temp tablespace in
question assigned to sys or system, stored procedures and packages will be
using it behind the scenes. Your users may be invoking a stored procedure
which uses a lot of temp space.
"Ms. D.H. Harvey" <qq45_at_liverpool.ac.uk> wrote in message
news:87rlst$8vl$1_at_news.liv.ac.uk...
> The following error is in the alert log for one of our databases:
> ORA-1652: unable to extend temp segment by 198 in tablespace
> DEVELOPMENT
> None of the users for this database has this tablespace assigned
> as their temporary tablespace. Pointers re where to start looking
> would be much appreciated.
>
> TIA Helen
Received on Wed Feb 09 2000 - 23:53:57 CST