table_space problem

Hello netters;

 I need help to overcome a space problem error I have been getting no matter how I structure the query.

 28 ;
ERROR:
ORA-01547: failed to allocate extent of size 956 in tablespace 'TEMPUSERS'

no rows selected

Elapsed: 00:14:34.81

We run Oracle V6,0.36.5.1 on a Unix plataform. I keep of running out of space and my DBA keep saying that we just don't have anymore resources.

table sizes followed :

table_1 	8918 blocks
sis_demand	1805 blocks
table_3         2715 blocks

Is there anyway to reduce the pool on the join without fragmenting report  or to use other table space without having to be logged in as DBA ?

Here is the queurey

select substr(table_3.isis_dept,3,2) isis_college,

       table_3.isis_dept,
       table_3.course,
       count(distinct (table_1.pid)) enrolled,
       count(distinct (sis_demand.pid))turnaway ,
       'ch' ch
from ir.table_1,
     ir.table_3,
     ir.sis_demand
where( table_3.sectid= table_1.sectid and 
      table_3.course = ir.sis_demand.course
      and not exists ( select a.pid
                       from ir.sis_demand a
                       where a.pid = table_1.pid and 
                             a.course = table_3.course and
                             a.term||'' ='SP93')) and
     (table_1.term||'' ='SP93' and
      table_3.term||'' ='SP93' and
     table_3.ri_census||'' ='Y' and
      sis_demand.term||'' = 'SP93' and 
       substr(table_3.isis_dept,3,2) in 
                (select isis_college 
                           from ir.college_table
                   where hrs_college is not null))
having count(distinct (table_1.pid)) < 
       count(distinct (sis_demand.pid))
group by substr(table_3.isis_dept,3,2),
         table_3.isis_dept,
         table_3.course




-------------------------------------------------------------------------------

     _                  _         _                            |
   /  )        /      /   )     /   /        /      ...  __o   |   ____  O O
 /  __.  __  /  _   /  .      /   /    _   /  .    ..   -\<,   |  (__^__) O
(__(_/|_/ (_(__(_) (__/|_\_\_// \_//\_(_)_(__/\     ..(_)/(_). |  ==(o)   O
                            / )  / )            On spare time  | On vacation !
                           (_/  (_/                            |


-------------------------------------------------------------------------------

Carlo Ciuffoli                      | Voice 303-491-6064
Computer Programmer                 | e-mail : ciuffoli_at_vienna.ir.colostate.edu
Budgets & Institutional Analysis    |        : ciuffoli_at_lamar.ColoState.edu
Colorado State University           | Disclaimer: my opinions are my own and not
Fort Collins,CO. 80525. Great U.S.A.|             of my employer.


-------------------------------------------------------------------------------