materialized view

[st2000]

Hi friends:
Oracle Version 8.1.6 on Sun Solaris
I have a table and on that table I have a mat.view.. When I populate this table automatically the view also should get populated. may be it does.. but when i try accessing that it gives me an ora-12514 error. why could that be..
I have checked for compatibility in init.ora and it is 8.1.0
I am working on the host system directly..
Thx.

[omegamark]

Materialized views are getting your output faster.It will be used by the optimezer.we SHOULD not use materialized view for normal selection purpose.

you create a mv on group function like sum,avg,max,min like that...

so when you querry sum(sal) optimizer will read the mv and get the output faster.MV will keep the sum value in the snapshot.

hope this helps a bit..