Re: Hint to parse on the remote site

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: jurgen_mortier@xxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • 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@xxxxxxxx <jurgen_mortier@xxxxxxxx> 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@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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


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


Other related posts: