Home » SQL & PL/SQL » SQL & PL/SQL » Error:ORA-03232: unable to allocate an extent of 15 blocks from tablespace 3
Error:ORA-03232: unable to allocate an extent of 15 blocks from tablespace 3 [message #4574] |
Mon, 23 December 2002 06:14 |
BABU SRSB
Messages: 42 Registered: June 2002
|
Member |
|
|
Hi all,
i was new to ORACLE. I am getting the below error after executing the below query. Please give the solution in Quick. please......
SQL> ED
Wrote file afiedt.buf
1 SELECT RDATE,
2 COUNT(CASE WHEN ((TYPE LIKE 'QUALIS') OR (TYPE LIKE 'SUMO')) THEN 1 END) TRIPS_QUALIS,
3 COUNT(CASE WHEN (TYPE LIKE 'INDICA') THEN 1 END) TRIPS_INDICA, COUNT(ROUTE_NO) TRIPS_TOTAL,
4 COUNT(CASE WHEN ((B2B LIKE 'Y') AND ((TYPE LIKE 'QUALIS') OR (TYPE LIKE 'SUMO'))) THEN 1 END) B2B_QUALIS,
5 COUNT(CASE WHEN ((B2B LIKE 'Y') AND (TYPE LIKE 'INDICA')) THEN 1 END) B2B_INDICA,
6 COUNT(CASE WHEN (B2B LIKE 'Y') THEN 1 END) B2B_TOTAL,
7 COUNT(CASE WHEN ((GUARD LIKE 'Y') AND ((TYPE LIKE 'QUALIS') OR (TYPE LIKE 'SUMO'))) THEN 1 END) GUARD_QUALIS,
8 COUNT(CASE WHEN ((GUARD LIKE 'Y') AND (TYPE LIKE 'INDICA')) THEN 1 END) GUARD_INDICA,
9 COUNT(CASE WHEN (GUARD LIKE 'Y') THEN 1 END) GUARD_TOTAL,
10 NVL(SUM(DECODE(TYPE, 'QUALIS', PAX, 'SUMO',PAX)),0) PPAX_QUALIS,
11 NVL(SUM(DECODE(TYPE, 'INDICA', PAX)),0) PAX_INDICA, NVL(SUM(PAX),0) PAX_TOTAL,
12 COUNT(CASE WHEN ((B2B_GUARD LIKE 'Y') AND (TYPE IN ('QUALIS', 'SUMO'))) THEN 1 END) B2B_GUARD_QUALIS,
13 COUNT(CASE WHEN ((B2B_GUARD LIKE 'Y') AND (TYPE LIKE 'INDICA')) THEN 1 END) B2B_GUARD_INDICA,
14 COUNT(CASE WHEN (B2B_GUARD LIKE 'Y') THEN 1 END) B2B_GUARD
15 FROM (SELECT DRAP.RDATE RDATE, DRAP.ROUTE_NO ROUTE_NO, DRAP.TYPE TYPE, DRAP.B2B B2B,
16 DRAP.GUARD GUARD, DRAP.PAX PAX, NVL(PICK.GUARD, 'N') B2B_GUARD
17 FROM (SELECT RDATE, ROUTE_NO, TYPE, B2B,B2B_ROUTE_NO, GUARD,
18 COUNT(DECODE(PAX_TYPE, 'R',1,'D',1)) PAX
19 FROM (SELECT RDATE, ROUTE_NO, PAX_TYPE, CAB_ID, NVL(B2B, 'N') B2B,B2B_ROUTE_NO,
20 NVL(GUARD, 'N') GUARD, TYPE
21 From TB_DROP_ACTUAL, TB_VENDOR_VEHICLE WHERE TRIM(CAB_ID)=VEHICLE_ID
22 AND RDATE BETWEEN '01-Dec-02' AND '22-Dec-02' AND UPLOADED_BY IS NOT NULL )
23 GROUP BY RDATE, ROUTE_NO, TYPE, B2B,B2B_ROUTE_NO, GUARD) DRAP,
24 (SELECT ROUTE_NO, GUARD FROM TB_PICK_ACTUAL
25 WHERE RDATE BETWEEN TO_DATE( '01-Dec-02', 'DD-MON-YY') AND TO_DATE('22-Dec-02','DD-MON-YY')+1
26 GROUP BY ROUTE_NO, GUARD) PICK
27 WHERE PICK.ROUTE_NO(+)=DRAP.B2B_ROUTE_NO)
28* GROUP BY RDATE
SQL> /
From TB_DROP_ACTUAL, TB_VENDOR_VEHICLE WHERE TRIM(CAB_ID)=VEHICLE_ID
*
ERROR at line 21:
ORA-03232: unable to allocate an extent of 15 blocks from tablespace 3
i got the above error after executing that big sql query.
i am not aware of the above error.
can any body please tell me of above error and give the solution to them.
waiting for the valuble solution.
Regards,
Babu.
|
|
|
|
Goto Forum:
Current Time: Mon May 20 21:32:45 CDT 2024
|