Hint to parse on the remote site

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