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 -
|
|
|
Goto Forum:
Current Time: Sun Sep 08 15:30:53 CDT 2024
|