Newbie - Need help increasing tablespace..

From: <bmolish_at_my-dejanews.com>
Date: Thu, 24 Sep 1998 17:25:14 GMT
Message-ID: <6udv9p$lhg$1@nnrp1.dejanews.com>

Our DBA has left, and I am the new admin person.. We are using Oracle 7.34 on a NT 4.0 box.

Currently when I run a SQL query I am getting the following error..

ORA-01652: unable to extend temp segment by 1598 in tablespace BTS1_7NS3;

When I check out the tablespace this is what I get.. By running the following..

select
tablespace_name,
sum(bytes),
max(bytes),
count(*)
from dba_free_space
group by tablespace_name
order by tablespace_name;

TABLESPACE_NAME                SUM(BYTES) MAX(BYTES)  COUNT(*)
------------------------------ ---------- ---------- ---------
BTS1_7NS3                        44541952   40589312         5
SYNCHRO_7NS3                      5855232    5640192         3
SYSTEM                           10455040   10455040         1

What is the exact command that I need to correct this error..

Thanks..

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 24 1998 - 12:25:14 CDT