Re: Hint to parse on the remote site
Date: Thu, 2 Oct 2008 16:52:32 +0100
i don't believe it possible . Youd want a 'NO_PARSE' hint, rather than remote parse. You could of course construct a view at the remote. Together with the DRIVING_SITE hint that should work. don'
On 02/10/2008, jurgen_mortier_at_amis.com <jurgen_mortier_at_amis.com> wrote:
> I'm using a hierarchical query from an Oracle 220.127.116.11.0 database that only
> accesses a table on a remote database (version 10.2.0.3.0).
> I'm trying to use the nocycle option, but since that does not exist on
> Oracle 9, I would like to get this query parsed on the Oracle 10 database.
> The hint DRIVING_SITE executes it on the remote site, but it is still
> parsed locally.
> Is this even possible ?
> The query is this:
> SELECT connect_by_iscycle cyc, level lvl, sys_connect_by_path((a.
> parent_lot_class || a.parent_lot_num),'/'), a.*
> FROM source_target_xref_at_remote_db a
> start with lot_class = 'ZW' and lot_num = 'GK140891'
> connect by nocycle parent_lot_class = prior lot_class and parent_lot_num =
> prior lot_num
> Jürgen Mortier
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 02 2008 - 10:52:32 CDT