AW: Re: ORA-01652 on none temporary tablespace

That is called a temp segment merge.

Von meinem Samsung Gerät gesendet.

• Ursprüngliche Nachricht -------- Von: Stefan Knecht <knecht.stefan_at_gmail.com> Datum: 23.06.2015 11:58 (GMT+01:00) An: seekuel_at_gmail.com Cc: oracle-l-freelists <oracle-l_at_freelists.org> 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 <seekuel_at_gmail.com> 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 11.2.0.3.0

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 23 2015 - 13:49:03 CEST