Home » Server Options » Replication » Snapshot Issue
Snapshot Issue [message #30975] Thu, 03 June 2004 01:26
Neeraj Bindal
Messages: 1
Registered: June 2004
Junior Member
- Dear Friends,

We are creating some MVs. One MV's query is returning the data but after MV creations, we are not getting any data in that MV. Query is as follow :

CREATE MATERIALIZED VIEW LOS_MV_REPO18_REPAY_FIRST
NOCACHE
NOPARALLEL
REFRESH FORCE
START WITH TRUNC(SYSDATE)
NEXT TRUNC(SYSDATE)+1
WITH ROWID
USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE AS
SELECT AGREEMENTID AGR,AGREEMENTID,A.AGREEMENTNO,A.APP_FORMNO,C.CUSTOMERNAME,
Los_Fn_Get_Coapplicant(AGREEMENTID) CO_APP,
P.DESCRIPTION,TO_CHAR(A.AMTFIN,'99,999,999,990.99') AMTFIN,
A.TENURE,
DECODE (A.FLOATINGFLG,'Y',TO_CHAR(PLRRATE,'99,999,999,990.99'),NULL) PLRRATE,
TO_CHAR(MARKUP,'99,999,999,990.99') MARGINMONEY,TO_CHAR(EFFRATE,'99,999,999,990.99') EFFRATE,
TO_CHAR(EMI,'99,999,999,990.99') EMI
FROM LEA_AGREEMENT_DTL_LMS A,
NBFC_CUSTOMER_M_LMS C,
NBFC_PRODUCT_M_LMS P
WHERE A.LESSEEID = C.CUSTOMERID
AND A.PRODUCTFLAG = P.CODE
AND A.STATUS <> 'X';

Please help me in identifying the reason.

With Rgds..

Neeraj -
Previous Topic: snapshot & materialised view in 9i
Next Topic: Exchange for cert stuff, Transcender for MCAD/MCSD.net etc
Goto Forum:
  


Current Time: Thu Mar 28 18:42:50 CDT 2024