Oracle Database Discussions

Hi!

Error starting at line 7 in command:
begin
    DBMS_MVIEW.REFRESH(list           => 'ROG_MV_FRM_OBIEKTY',
                       method         => 'c',    -- complete
                       atomic_refresh => true);
  end;
Error report:
ORA-12008: błąd w ścieżce odświeżania zmaterializowanej perspektywy
ORA-01722: niepoprawna liczba
ORA-06512: przy "SYS.DBMS_SNAPSHOT", linia 2254
ORA-06512: przy "SYS.DBMS_SNAPSHOT", linia 2460
ORA-06512: przy "SYS.DBMS_SNAPSHOT", linia 2429
ORA-06512: przy linia 2
12008. 00000 -  "error in materialized view refresh path"
*Cause:    Table SNAP$_<mview_name> reads rows from the view
           MVIEW$_<mview_name>, which is a view on the master table
           (the master may be at a remote site).  Any
           error in this path will cause this error at refresh time.
           For fast refreshes, the table <master_owner>.MLOG$_<master>
           is also referenced.
*Action:   Examine the other messages on the stack to find the problem.
           See if the objects SNAP$_<mview_name>, MVIEW$_<mview_name>,
           <mowner>.<master>@<dblink>, <mowner>.MLOG$_<master>@<dblink>
           still exist.

How to deal with that?
All the 2 master tables are local. The MV is defined as

create materialized view ROG_MV_FRM_OBIEKTY 
  parallel 4
  BUILD DEFERRED
  refresh fast with rowid
  on commit
as
  SELECT l.rowid  AS l_rowid,
         lk.rowid AS lk_rowid,
         log_id,
         log_obk_id,
         log_obk_typ,
         logkz_log_id,
         logkz_modul_ksat,
         rog_pck_utl.g5_dsp(log_obk_typ, log_obk_id) AS log_obk_dsp
    FROM rog_log l,
         rog_log_ksat_zdarzenia lk
   WHERE logkz_log_id = log_id
     AND logkz_f_obsluzony = 'N';

Oracle 10.2.0.3

Edited by: JackK on Feb 16, 2011 5:04 AM