Hi Stefan,
Thank you for detailed steps. In our scenario, does it also apply in insert
and update? When the error occurs its mostly when there is an update or
insert. We used the database for datawarehouse.
Thank you
On Tue, Jun 23, 2015 at 5:58 PM, Stefan Knecht <knecht.stefan@xxxxxxxxx>
wrote:
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
