ORA-01652 on none temporary tablespace
From: seekuel <seekuel_at_gmail.com>
Date: Tue, 23 Jun 2015 16:26:16 +0800
Message-ID: <CABgN9w82MyLMxPqawDgZ0TcDwRPKpEp0vJ2RLCS7eqDm57muog_at_mail.gmail.com>
Hi All,
Date: Tue, 23 Jun 2015 16:26:16 +0800
Message-ID: <CABgN9w82MyLMxPqawDgZ0TcDwRPKpEp0vJ2RLCS7eqDm57muog_at_mail.gmail.com>
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-lReceived on Tue Jun 23 2015 - 10:26:16 CEST