Calling Oracle is useless. I have had a TAR open
since 5/11 on Mviews. Send me the error and I might
have seen it. I have been struggling with MViews for
almost a year.
Here are some hints:
1) Does the user have create materialized view, alter
materialized view, query rewrite granted to it?
2) Is the query_rewrite_integrity set in your
init.ora?
3) What is your job_queue_processes set to in your
init.ora?
- Helmut Daiminger <hdaiminger_at_vivonet.com> wrote:
> Hi!
>
> I'm fairly new to materialized views... Why can't I
> create this MV (the
> error message description doesn't help much).
>
> Create Materialized View MVTabs
> BUILD IMMEDIATE REFRESH ON COMMIT
> as
> SELECT * FROM TBTABS WHERE TABSTATUS=3;
>
>
> Thanks,
> Helmut
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Helmut Daiminger
> INET: hdaiminger_at_vivonet.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Regards,
Linda Miller-Coker
My auctions are at:
auctions.yahoo.com/booth/tazmacc
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
Received on Fri Oct 13 2000 - 07:19:42 CDT