Björn Wächter wrote:
> We are using 10g 10.1.0.2.0 on debian.
> The MV is created by:
>
> CREATE MATERIALIZED VIEW CP.MV_DAYS
> TABLESPACE P3DEV
> NOCACHE
> LOGGING
> NOCOMPRESS
> NOPARALLEL
> BUILD IMMEDIATE
> REFRESH FORCE ON DEMAND
> WITH ROWID
> AS
> SELECT
> DAYDATE, UP_PRO, DOWN_MIN, SORTED
> FROM VI_DAYS;
No guarantee but it should be visible in OEM when observing
V$SESSION_LONGOP view.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Nov 14 2005 - 13:29:46 CST
