Re: Hint to parse on the remote site

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:
>
> Hi,
>
> I'm using a hierarchical query from an Oracle 9.2.0.4.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
>
> Regards
> Jürgen Mortier
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l