You may use the below script to find out which Tablespace is full and
how much free space is left:
Log in as system/manager and run the below script "free.sql"
Free.sql
---------
column dummy noprint
column pct_used format 999.9 heading "%|Used"
column name format a16 heading "Tablespace Name"
column Kbytes format 999,999,999 heading "KBytes"
column used format 999,999,999 heading "Used"
column free format 999,999,999 heading "Free"
column largest format 999,999,999 heading "Largest"
break on report
compute sum of kbytes on report
compute sum of free on report
compute sum of used on report
select nvl(b.tablespace_name,
nvl(a.tablespace_name,'UNKOWN')) name,
kbytes_alloc kbytes,
kbytes_alloc-nvl(kbytes_free,0) used,
nvl(kbytes_free,0) free,
((kbytes_alloc-nvl(kbytes_free,0))/
kbytes_alloc)*100 pct_used,
nvl(largest,0) largest
from ( select sum(bytes)/1024 Kbytes_free,
max(bytes)/1024 largest,
tablespace_name
from sys.dba_free_space
group by tablespace_name ) a,
( select sum(bytes)/1024 Kbytes_alloc,
tablespace_name
from sys.dba_data_files
group by tablespace_name )b
where a.tablespace_name (+) = b.tablespace_name
/
-----Original Message-----
From: akki
[mailto:oracledba-ezmlmshield-x45937873.[Email address protected]
Sent: Tuesday, November 23, 2004 6:03 AM
To: LazyDBA Discussion
Subject: RE: ORA-03232 unable to allocate an extent of 34 blocks from
tablespace 3
hi ..
i think it has something to
do with the quota alloted to the particular user
in the given tablespace
see for it...
bye
akki
-----Original Message-----
From: Nigam Niranjan [mailto:oracledba-ezmlmshield-x66798560.[Email
address protected]
Sent: Tuesday, November 23, 2004 4:20 PM
To: LazyDBA Discussion
Subject: RE: ORA-03232 unable to allocate an extent of 34 blocks from
tablespace 3
Hi,
You can check the following -
Login as system and select ts#, name from v$tablespace where ts#=3
The tablespace name you get is full and you either need to extend it or
add a datafile to it,
Regards,
- Niranjan
-----Original Message-----
From: Muhammad Mohsin [mailto:oracledba-ezmlmshield-x55842527.[Email
address protected]
Sent: Tuesday, November 23, 2004 3:36 PM
To: LazyDBA Discussion
Subject: ORA-03232 unable to allocate an extent of 34 blocks from
tablespace 3
HI,
I have updated by database from Oracle 8.1.6 to Oracle 8.1.7. Previously
every thing was working fine but in new release one user is giving the
error on running some reports "ORA-03232 unable to allocate an extent of
34 blocks from tablespace 3". Report is based on a view , if same view
is run from other user it does not give any error.
Please help to resolve it.
Thanks
Muhammad Mohsin
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page