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,

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 - 10:26:16 CEST

Original text of this message