Home » RDBMS Server » Server Administration » ORA-03232: unable to allocate an extent of 16 blocks from tablespace 3
ORA-03232: unable to allocate an extent of 16 blocks from tablespace 3 [message #187343] Sat, 12 August 2006 06:59 Go to next message
anupam_j_patel
Messages: 1
Registered: August 2006
Junior Member
Dear Sir/Madam,

I am getting following error when executing one of the query in oracle 8i database. Please let me know solution for the same.

ORA-03232: unable to allocate an extent of 16 blocks from tablespace 3

Query:select a.emp_id_pd,c.emp_name,hq_name,max(case when band in (8,9,10) then 'OE/OC/FRO' when band=7 then 'SOE' when band=6 then 'MO' when band=5 then 'SMO' when band=4 then 'ADO' when band=3 then 'DO' end) as desig,count(distinct tr_date) as wdays,d.zone_id ,nvl(round(sum( case when b.type_activity_code in (93,94,95,96,97) then (to_date(to_time_spent,'hh24:mi')-to_date(from_time_spent,'hh24:mi'))*24.0 end),2),0) as awork ,nvl(round(sum( case when b.type_activity_code in (1,3,5,6,7,8,9,12,16,17,18,19,20,31) then (to_date(to_time_spent,'hh24:mi')-to_date(from_time_spent,'hh24:mi'))*24.0 end),2),0) as arelated ,nvl(round(sum( case when b.type_activity_code in (98,100) then (to_date(to_time_spent,'hh24:mi')-to_date(from_time_spent,'hh24:mi'))*24.0 end),2),0) as holiday ,nvl(round(sum( case when b.type_activity_code in (39) then (to_date(to_time_spent,'hh24:mi')-to_date(from_time_spent,'hh24:mi'))*24.0 end),2),0) as jday ,nvl(round(sum( case when b.type_activity_code in (37) then (to_date(to_time_spent,'hh24:mi')-to_date(from_time_spent,'hh24:mi'))*24.0 end),2),0) as ltravel ,nvl(round(sum( case when b.type_activity_code in (32,33,34,62,63,64,65,66,67,69) then (to_date(to_time_spent,'hh24:mi')-to_date(from_time_spent,'hh24:mi'))*24.0 end),2),0) as mtraining ,nvl(round(sum( case when b.type_activity_code in (2,4,10,11,13,14,15,21,22,23,24,25,26,27,28,35,36,40,41,42,43,44) then (to_date(to_time_spent,'hh24:mi')-to_date(from_time_spent,'hh24:mi'))*24.0 end),2),0) as ofield ,nvl(round(sum( case when b.type_activity_code in (38) then (to_date(to_time_spent,'hh24:mi')-to_date(from_time_spent,'hh24:mi'))*24.0 end),2),0) as otravel from timesheet_master a,timesheet_details b,orgmarg.employee c,orgmarg.headquarters d where a.time_sheet_code =b.time_sheet_code and a.emp_id_pd=c.emp_id_pd and b.sub_type=0 and c.hq_id=d.hq_id and to_date(tr_date,'dd/mm/yyyy') between to_date('01/06/2006','dd/mm/yyyy') and to_date('30/06/2006','dd/mm/yyyy') group by a.emp_id_pd,c.emp_name,hq_name,d.zone_id

From
Anupam
Re: ORA-03232: unable to allocate an extent of 16 blocks from tablespace 3 [message #187359 is a reply to message #187343] Sat, 12 August 2006 12:47 Go to previous message
ramakris
Messages: 21
Registered: July 2006
Location: Delhi
Junior Member
Look into the alert log to identify the tablespace, and then increase the space in it.

Thanks!
Previous Topic: archive logging
Next Topic: full export error
Goto Forum:
  


Current Time: Sun Dec 04 06:54:44 CST 2016

Total time taken to generate the page: 0.09930 seconds