driving_site hint in Materialized View definition

From: Veeru71 <m_adavi_at_hotmail.com>
Date: Sat, 27 Jun 2009 05:24:09 -0700 (PDT)
Message-ID: <b7d2085b-1330-45d0-bdfa-8b037814dff6_at_p18g2000pra.googlegroups.com>

Is there any restrinction on using DRIVING_SITE hint in materialized view definition ?
It seems to be ignoring the hint and is transferring the remote EMP table data (which is huge compared to the local DEPT table) to the local server for the join.

The hint works perfectly fine if I run just the SELECT statement.

CREATE MATERIALIZED VIEW EMP_MV
REFRESH COMPLETE ON DEMAND WITH PRIMARY KEY AS
SELECT /*+DRIVING_SITE(e)*/ e.empno, e.empname , ......... FROM emp_at_RSITE e, dept d
WHERE e.deptno = d.deptno;

We are using Oracle 10.2.0.4
Thanks for your help. Received on Sat Jun 27 2009 - 07:24:09 CDT