Oracle Database Discussions

Hi,

It seems to be a bug with oracle db 10.2.0.1 and its prod. env i can't apply the patch quickly, Can anyone give me a hint

CREATE MATERIALIZED VIEW MV_TEN
BUILD IMMEDIATE USING INDEX REFRESH COMPLETE ON DEMAND
AS
SELECT ten.tcy_refno AS TENANCY_REF,
rev.rac_accno AS REV_ACC_NO,
rev.rac_last_aba_date AS LAST_ABA_DATE,
rev.rac_last_aba_balance AS LAST_ABA_BALANCE,
aaa.aca_status AS ARREARS_STATUS,
aaa.aca_ara_code AS ARREARS_ACTION_CODE,
aaa.aca_effective_date AS EFFECTIVE_DATE,
aaa.aca_balance AS ACCOUNT_BALANCE,
ara.ara_description AS ARREARS_DESCRIPTION,
npa.nop_text
FROM REVENUE@remotedb rev,
TENANCT@remotedb ten,
ACCOUNT_ARREARS_ACTIONS@remotedb aaa
LEFT OUTER JOIN ARREARS_ACTIONS@remotedb ara
ON aaa.aca_ara_code = ara.ara_code
LEFT OUTER JOIN NOTEPADS@remotedb npa
ON aaa.aca_reusable_refno = npa.nop_reusable_refno
WHERE ten.tcy_refno = rev.rac_tcy_refno
AND rev.rac_end_date IS NULL
AND rev.rac_accno = aaa.aca_rac_accno
AND aaa.aca_status != 'DEL'
AND npa.nop_current_ind = 'Y';

ora-00907 : missing right paraenthesis


Thanks