joins and ORA-12015

From: Vadim theHook <kezal_at__RMV_IT_mail.ru>
Date: Wed, 10 Dec 2003 16:52:36 +0300
Message-ID: <br78e9$1qk$1@n6.co.ru>

Hello All!

My wuestion concerning problem creating mat. view with INNER JOIN and FAST REFRESH mode

I've studied Note:236486.1. It mentioned "joins which occur in both the query and in the MV" (MV == Materialized View). What does it mean, "join in query" and what's the difference from "join in MV"?

• cut === STEP 8 : JOIN COMPATIBILITY CHECK

  ---

The Join Compatibility checks that the joins in the MV are compatible with the joins in the query.

It is only performed for MVs that have joins (Join-only MVs or MVs with both Joins & Aggregates).

It is not performed for single-table Aggregate MVs.

8a) Find the joins which occur in both the query and in the MV. These
					^^^^^^^^^^^^^^^^^^^^^^^^^

are the Common joins.

8b) Find the joins which occur in the query but not in the MV. These are the Query Delta joins.

The Join Compatibility check succeeds for these joins. ...
=== cut ===

Rgds, Vadim Grepan

--
Moscow, Russia

Received on Wed Dec 10 2003 - 07:52:36 CST