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;
"DA Morgan" <damorgan_at_psoug.org> schrieb im Newsbeitrag
news:1131982935.609368_at_yasure...
> Björn Wächter wrote:
>> Hi all,
>>
>> is there a way to see the progress of a
>> materialized create/refresh?
>> I read something about an info in
>> v$session_longops
>> but couldn't see anything there.
>>
>> Thanks Björn
>
> Oracle version? Type of materialized 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 - 09:54:12 CST
