By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,784 Members | 3,274 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,784 IT Pros & Developers. It's quick & easy.

Materialized view

P: 78
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
Sep 17 '07 #1
Share this Question
Share on Google+
2 Replies


debasisdas
Expert 5K+
P: 8,127
kindly post the exact error message with error number

also post how r u refreshing the materialized view.
Sep 17 '07 #2

P: 16
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
Nov 9 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.