UPDATE /*+ bypass_ujvc */
(
    SELECT CPI.COMPID, CPI.COMP_NAME, PSO.PERSAMMFSN, PSO.STATE, PSO.USERLEVEL FROM PERSAMOBULEDGER PSO, COMPANYINFO CPI
    WHERE PSO.COMPID = CPI.COMPID(+)
    AND PSO.REGDATE BETWEEN '20040101' AND '20140404'
    AND CPI.COMP_LEVEL = '03'
    AND CPI.PLACECODE <> 'R'
    AND PSO.STATE = '04'
    AND PSO.USERLEVEL != '2'
    MINUS
    SELECT CPI.COMPID, CPI.COMP_NAME, PSO.PERSAMMFSN, PSO.STATE, PSO.USERLEVEL FROM PERSAMOBULEDGER PSO, COMPANYINFO CPI
    WHERE PSO.COMPID = CPI.COMPID(+)
    AND PSO.REGDATE BETWEEN '20040101' AND '20140404'
    AND CPI.COMP_LEVEL = '03'
    AND CPI.PLACECODE <> 'R'
    AND PSO.STATE = '04'
    AND PSO.USERLEVEL != '2'
    AND PSO.USERLEVEL != '1'
)
SET USERLEVEL = '2'
;

위 쿼리를 보면 USERLEVEL 컬럼에 일괄로 '2'로 업데이트를 칠려하는데....
에러의 원인을 모르겠습니다.
minus를 쓴 이유는 minus 밑의 쿼리에 데이터 하나를 빼고 칠려 minus를 썼는데.....
ㅠㅠ
답변 부탁드립니다.