Hint to parse on the remote site
- From: jurgen_mortier@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 2 Oct 2008 17:02:09 +0200
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
Other related posts:
