Re: mview and ora - 12079

Well, do this from SQL*PLUS and show it to your DBA and demand that he change it in the init.ora file.

select name, value from v$parameter where name like 'comp%';

ashrivastava_at_auriga-insys.com (Anand) wrote in message news:<396cc940.0209042256.11c522b3_at_posting.google.com>...
> Hi,
>
> I am using Oracle 8.1.6 with Win2k.
> I am trying to create a materialized view using following command
>
> create MATERIALIZED VIEW
> mytable_mview
> REFRESH ON COMMIT
> as
> select * from mytable
>
> In turn I recieve following error:
> ORA-12079: snapshot options require COMPATIBLE parameter to be
> 8.1.0.0.0 or
> greater
>
> If i remove the refresh option and issue following command then the
> mview is created succesfully
>
> create MATERIALIZED VIEW
> mytable_mview
> REFRESH ON COMMIT
> as
> select * from mytable
>
> I looked up for the error and found following info:
> Cause: The following snapshot options require 8.1 or higher
> compatibility setting:ON COMMIT ON PREBUILT TABLE BUILD DEFERRED NEVER
> REFRESH ENABLE QUERY REWRITE
> Action: Shut down and restart with an appropriate compatibility
> setting.
>
> I am not able to figure it out, what is a compatibility setting and
> how do we specify it?
> Please help
>
> Regards,
> Anand
Received on Thu Sep 05 2002 - 19:10:37 CEST