That is called a temp segment merge.
Von meinem Samsung Gerät gesendet.
-------- Ursprüngliche Nachricht --------
Von: Stefan Knecht <knecht.stefan@xxxxxxxxx>
Datum: 23.06.2015 11:58 (GMT+01:00)
An: seekuel@xxxxxxxxx
Cc: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx> 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
