HansF wrote:
> On Fri, 21 Oct 2005 14:40:13 -0400, JS interested us by writing:
>
>
>
>>Now I get
>>
>>ORA-20000: Invalid CREATE MATERIALIZED VIEW statement because of:
>>ORA-00942: table or view does not exist
>
>
> It is truly commendable that you are trying to use the Materialized View
> (MV) feature of the database.
>
> You seem to have a few gaps in understanding what MVs are and how they
> work. I highly recommend reading the short chapter in the "Oracle9i Data
> Warehousing Guide" which discusses all of this in detail, including how
> and when to create and manage them and how to handle the above error.
>
> For your convenience, the direct link (which may be wrapped) to the doc is
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/mv.htm#721
>
I never used materialized views before. I tried searching in
documentation library
http://otn.oracle.com/pls/db10g/portal.portal_demo3
but had little luck.
Thank you for your help.
Received on Mon Oct 24 2005 - 08:18:30 CDT