Materialized view

[holdingbe]

Hi,
I created a materialized view. when i refresh that views, it shows error like
this materialized view not present...

I created materialized logs also.....



Regards
Michael

[debasisdas]

kindly post the exact error message with error number

also post how r u refreshing the materialized view.

[Vinod Sadanandan]

Mike,

Please paste the exact ORA- error message from your end ,meanwihle use this simple steps mentioned below as a testcase for checking materialized view.

1)connect scott/tiger
2)alter table dept add constraint pk_dept primary key(deptno);
3)create materialized view log on dept;
4)create materialized view s_dept refresh fast as select * from dept;

5)If you select from the materialized view log you should see a row count of 1.

select count(*) from mlog$_dept;
1 row selected

6)The below procedure will devalidate internal triggers which populates
the materialized view log when modification are done on the master table:

execute DBMS_MVIEW.BEGIN_TABLE_REORGANIZATION('SCOTT','DEP T');
7) Refresh the materialized view, default is refresh method indicated in DBA_MVIEWS.
execute dbms_mview.refresh('S_DEPT','f');


Thanks & Regards,
Vinod Sadanandan
Oracle DBA