ORA-01652 on none temporary tablespace

  • From: seekuel <seekuel@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 23 Jun 2015 16:26:16 +0800

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2015