Re: Oracle 8.1.7 problem creating simple materialized view

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 07 Mar 2006 20:54:24 +0100
Message-ID: <duknh2$7o4$1@news4.zwoll1.ov.home.nl>

Jack wrote:
[snip!]
> SQL> CREATE MATERIALIZED VIEW thresholds_ak
> 2 as
> 3 SELECT * FROM thresholds_ak_at_ak_test;


Explain this------------------^^^^^^^^^^^^

Versus:

------------------------vvvvvvvvvvvvvvvv


> SELECT * FROM op_leave_thresholds_at_rmop

>        *

iirc, GLOBAL_NAMES should be TRUE, and you are having some synonyms or are not telling the whole story.

That is the rmap Hans was referring to, I suspect

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Tue Mar 07 2006 - 13:54:24 CST