AW: Re: ORA-01652 on none temporary tablespace

From: l.flatz <>
Date: Tue, 23 Jun 2015 13:49:03 +0200
Message-ID: <>


That is called a temp segment merge.

Von meinem Samsung Gerät gesendet.

  • Ursprüngliche Nachricht -------- Von: Stefan Knecht <> Datum: 23.06.2015 11:58 (GMT+01:00) An: Cc: oracle-l-freelists <> Betreff: Re: ORA-01652 on none temporary tablespace

This is something that Oracle does if you're running DDL statements such as create table as select or create index. Oracle will allocate the segment as temporary, populate it with data and then flag it as a permanent segment before completing the operation (in very roughly outlined steps).

On Tue, Jun 23, 2015 at 3:26 PM, seekuel <> wrote: Hi All,
We got an error ORA-01652 on tablespace LL_DATA. LL_DATA is not a temporary tablespace. There is still a 14G free for the tablespace use. error:ORA-01652: unable to extend temp segment by 32 in tablespace LL_DATA our database version is

This is a bit confusing and I am hoping that someone might came across with this type of scenario and help with troubleshooting.

Thank you

-- Received on Tue Jun 23 2015 - 13:49:03 CEST

Original text of this message