Re: ORA 1652

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Wed, 9 Feb 2000 10:29:47 -0500
Message-ID: <87s175$16l$1@bob.news.rcn.net>

It could happen if a server process can not allocate a new temporary segment in the dedicated "public" temporary tablespace (with TEMPORARY attribute) due to the its size or status (offline) issues. In that case this server process attempts to allocate needed temporary segment in another available tablespace (which is DEVELOPMENT in your case) quoted for the user the server process is initiated on behalf.

Eugene.

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
> > 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 - 09:29:47 CST