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
