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