Re: ORA 1652

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 9 Feb 2000 13:46:49 +0100
Message-ID: <950100546.4258.0.pluto.d4ee154e@news.demon.nl>

When an index is created it will initially also show up as a temporary segment. This segment, when ready, is renamed behind the scenes to the name of the index.

Hth,

Sybrand Bakker, Oracle DBA

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 - 06:46:49 CST