Re: driving_site hint in Materialized View definition
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 1 Jul 2009 08:28:04 +0100
Message-ID: <mdednfGhiIefjdbXnZ2dnUVZ8tSdnZ2d_at_bt.com>
"Yong Huang" <yong321_at_yahoo.com> wrote in message news:06ac8013-c447-45b7-bc73-8a8cd452329b_at_l32g2000vba.googlegroups.com...
> On Jun 27, 9:11 am, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk>
> wrote:
>>
>> The driving_site() hint is not legal in "create as select"
>> or "insert as select". The select statement has to operate
>> at the database where the create or insert takes place.
>>
>> I think if you search metalink, you'll find a note that makes
>> this point - but I don't have a reference to the doc ID.
>
> Metalink Note:825677.1 says in
>
> insert /* DRIVING_SITE(remote_example_data) */ into example_data
> select /* DRIVING_SITE(remote_example_data) */ remote_example_data.*
> from ...
>
> the first driving_site hint, the one after insert, is ignored. That
> must be the note you're referring to?
>
> Yong Huang
Date: Wed, 1 Jul 2009 08:28:04 +0100
Message-ID: <mdednfGhiIefjdbXnZ2dnUVZ8tSdnZ2d_at_bt.com>
"Yong Huang" <yong321_at_yahoo.com> wrote in message news:06ac8013-c447-45b7-bc73-8a8cd452329b_at_l32g2000vba.googlegroups.com...
> On Jun 27, 9:11 am, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk>
> wrote:
>>
>> The driving_site() hint is not legal in "create as select"
>> or "insert as select". The select statement has to operate
>> at the database where the create or insert takes place.
>>
>> I think if you search metalink, you'll find a note that makes
>> this point - but I don't have a reference to the doc ID.
>
> Metalink Note:825677.1 says in
>
> insert /* DRIVING_SITE(remote_example_data) */ into example_data
> select /* DRIVING_SITE(remote_example_data) */ remote_example_data.*
> from ...
>
> the first driving_site hint, the one after insert, is ignored. That
> must be the note you're referring to?
>
> Yong Huang
I should have remembered I had a note on my blog about distributed DML and the irrelevant of the driving_site() hint for DML. It references the metalink note - and reminds me that it was Joel Goodman who pointed it out to me.
http://jonathanlewis.wordpress.com/2008/12/05/distributed-dml/
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Wed Jul 01 2009 - 02:28:04 CDT