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


Oracle LazyDBA home page