Insufficient memory for this operation 에라가 나는데요 왜그런가요 ?
환경>
델 5에 오라클 7.3 사용 OS WIN98 이고요
Query 에 sql문 에 (
SELECT * FROM MONMAST
WHERE YE = :pYe AND
MO = :pMo
ORDER BY CODE )
문장을 넣고 ACTIVE 에 TRUE 하면 아래와 같은 결과
1. TABLE 생성하고 FILED 62개 일때는 이상무
2. TABLE 생성하고 FILED 67개 일때는 에라가 남
위 1번일때는 JOIN 하면 에라가납니다
query 에 sql문장(SELECT INS.CODE,
INS.NAME INSNAME,
INS.DEPT,
INS.JIKCHK,
INS.INDATE,
INS.OUTDATE,
DPT.NAMES DPTNAME,
JOBM.NAMES JIKNAME,
Mon.*
FROM INSMAST INS, JOBMAST JOBM, DPTMAST DPT,MONMAST MON
WHERE INS.DEPT = DPT.CODE(+) AND
INS.JIKCHK = JOBM.KEYCODE(+) AND
INS.CODE(+) = MON.CODE AND
INS.DEPT BETWEEN :pSDept AND :pEDept AND
INS.CODE BETWEEN :pSCode AND :pECode AND
MON.YE = :pYe AND
MON.MO BETWEEN :pSMo AND :pEMo)
<참고테이블>
CREATE TABLE MonMast (
YE CHAR(4) NOT NULL ,
MO NUMBER(2,0) NOT NULL ,
CODE CHAR(8) NOT NULL ,
Day Number(2,0) , /* NEW*/ 추가부분
Dept CHAR(5), /* NEW*/
JIKCHK CHAR(4), /* NEW*/
JIKMU CHAR(4), /* NEW*/
JIDate DATE ,
EndDate Date , /*NEW*/
EndGbn CHAR(1), /*계산종료구분*/
DateAmt1 NUMBER(7,0) , /*일급*/
DateAmt2 NUMBER(7,0) , /*통상일급*/
MONSAMT1 NUMBER(12,0) , /*기본급*/
MONSAMT2 NUMBER(12,0) , /*능력급*/
SANGAMT NUMBER(12,0) ,
JUNGSAN NUMBER(9,0) , /*정산환급*/
WOLJUNG NUMBER(10,0) ,
TAXAMT NUMBER(10,0) ,
NTAXAMT NUMBER(10,0) ,
TOTAMT NUMBER(10,0) ,
HSAMT NUMBER(9,0) ,
PEAMT NUMBER(9,0) ,
SCSAMT NUMBER(12,0) ,
GNSEAMT NUMBER(9,0) ,
Goje01 NUMBER(9,0) ,
Goje02 NUMBER(9,0) ,
Goje03 NUMBER(9,0) ,
KABGN NUMBER(12,0) ,
JUMIN NUMBER(12,0) ,
GONGTOT NUMBER(12,0) ,
NETPAY NUMBER(12,0),
TAXNO01 NUMBER(9,0) ,
TAXNO02 NUMBER(9,0) ,
TAXNO03 NUMBER(9,0) ,
TAXNO04 NUMBER(9,0) ,
TAXNO05 NUMBER(9,0) ,
TAXNO06 NUMBER(9,0) ,
TAXNO07 NUMBER(9,0) ,
TAXNO08 NUMBER(9,0) ,
TAXNO09 NUMBER(9,0) ,
TAXNO10 NUMBER(9,0) ,
TAXNO11 NUMBER(9,0) ,
TAXNO12 NUMBER(9,0) ,
TAXNO13 NUMBER(9,0) ,
TAXNO14 NUMBER(9,0) ,
TAXNO15 NUMBER(9,0) ,
TAXNO16 NUMBER(9,0) ,
TAXNO17 NUMBER(9,0) ,
TAXNO18 NUMBER(9,0) ,
TAXNO19 NUMBER(9,0) ,
TAXNO20 NUMBER(9,0) ,
GNGNO01 NUMBER(9,0) ,
GNGNO02 NUMBER(9,0) ,
GNGNO03 NUMBER(9,0) ,
GNGNO04 NUMBER(9,0) ,
GNGNO05 NUMBER(9,0) ,
GNGNO06 NUMBER(9,0) ,
GNGNO07 NUMBER(9,0) ,
GNGNO08 NUMBER(9,0) ,
GNGNO09 NUMBER(9,0) ,
GNGNO10 NUMBER(9,0) ,
GNGNO11 NUMBER(9,0) ,
GNGNO12 NUMBER(9,0) ,
GNGNO13 NUMBER(9,0) ,
GNGNO14 NUMBER(9,0) ,
GNGNO15 NUMBER(9,0) ,
GNGNO16 NUMBER(9,0))
CREATE INDEX MONMastIDX ON MONMast (YE,MO,Code ASC)