unable to extent temp segment

From: Grt <grt_post_at_hotmail.com>
Date: Mon, 24 May 1999 15:31:48 +0200
Message-ID: <374954C4.133FDFBA@hotmail.com>

When creating an index in the USR tablespace I received the 'unable to extent message':

SQL> create index objects_2_i
  2  on objects_2(obj#);
on objects_2(obj#)
   *
ERROR at line 2:
ORA-01652: unable to extend temp segment by 27 in tablespace USR

But DBA_FREE_SPACE said there was enough space (27 * 2048 =55296):

SQL> select bytes
  2  from dba_free_space
  3  where TABLESPACE_NAME = 'USR';

     BYTES
----------
    151552
     53248
     20480

Anyone? Received on Mon May 24 1999 - 08:31:48 CDT