extent of 127 blocks !!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: extent of 127 blocks !!!

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width