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
|
] 
Blog
Search
Help
Members
Register
Login
Home
