Here is the MV log and the MV, it's generating an
ORA-12032 when trying a refresh fast.
create MATERIALIZED VIEW log on sp_ect_etat_contrat
with primary key
(ECt_ID_PRODUIT,
ECt_CD_SERIE ,
ECt_CD_SOURCE ,
ECt_CD_AGENCE ,
ECt_CD_APPORTEUR ,
ECt_BT_ENCOURS ,
ECt_CD_ETAT ,
ECt_BT_VEP ,
ECt_BT_RPP ,
ECt_BT_NANTISSEMENT ,
ECt_MT_VALEUR_ACQUISE)
including new values ;
create materialized view admindba.sp_aec_agg_etat_ctr
nologging
build deferred
refresh fast
on demand
with primary key
enable query rewrite
as select
count(*) compte,
count(ECt_MT_VALEUR_ACQUISE) compte_MT_VALEUR_ACQUISE,
ECt_DT_ALIM ,
ECt_ID_PRODUIT,
ECt_CD_SERIE ,
ECt_CD_SOURCE ,
ECt_CD_AGENCE ,
ECt_CD_APPORTEUR ,
ECt_BT_ENCOURS ,
ECt_CD_ETAT ,
ECt_BT_VEP ,
ECt_BT_RPP ,
ECt_BT_NANTISSEMENT ,
sum(ECt_MT_VALEUR_ACQUISE) somme_ECt_MT_VALEUR_ACQUISE
from admindba.sp_ect_etat_contrat
group by
ECt_DT_ALIM ,
ECt_ID_PRODUIT,
ECt_CD_SERIE ,
ECt_CD_SOURCE ,
ECt_CD_AGENCE ,
ECt_CD_APPORTEUR ,
ECt_BT_ENCOURS,
ECt_CD_ETAT ,
ECt_BT_VEP ,
ECt_BT_RPP ,
ECt_BT_NANTISSEMENT ;
- Ranganath K <ranganathk_at_subexgroup.com> a écrit :
> Hi Stephane,
>
> Could you send me the Create materialized view
> statement so that I can
> have a look at it.
>
> Regards,
>
> Ranganath
>
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On
> Behalf Of paquette
> stephane
> Sent: Friday, April 13, 2001 7:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Fwd: Materialised view
>
>
> I've sent that mail days ago with no feedback,
> Oracle
> Support hasn't been able help, anybody ?
>
> On Oracle 816/Solaris 5.7, I'm trying to refresh
> fast
> a mview without success: ORA-12032.
> It's a mview with single table aggregate, I've
> followed all the restrictions in the doc (I'm having
> a mview log, count is present,... )
>
> I can refresh force but it's doing a complete not a
> fast refresh.
> Why ?
>
>
>
>
> =====
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> stephane_paquette_at_yahoo.com
>
>
> Do You Yahoo!? -- Pour dialoguer en direct avec vos
> amis,
> Yahoo! Messenger : http://fr.messenger.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Pour dialoguer en direct avec vos amis,
Yahoo! Messenger :
http://fr.messenger.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Apr 17 2001 - 09:40:01 CDT
