-
extent of 127 blocks !!!
8.1.7 advance server linux.
I was getting this error message from application.
java.sql.SQLException: ORA-03232: unable to allocate an extent of 127 blocks
from tablespace 3
at com.pronto.jsp_tags.GetCustomerAccountsTag.doStartTag
(GetCustomerAccountsTag.java:64)
at _CustomerAccountsSearch._jspService
(_CustomerAccountsSearch.java:1376)
SQL> select name from v$tablespace where ts# = 3;
NAME
------------------------------
TEMP
Free space in temp tablespace is almost 2 gb.
select bytes,file_ID from dba_free_space where tablespace_name='TEMP' order by 1;
65536 4
65536 4
65536 4
65536 4
65536 4
65536 4
65536 4
65536 4
65536 4
65536 4
65536 4
65536 4
7729152 4
838856704 19
1194782720 17
where is the issue.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|