Help -- ERROR: piece-wise fetching

From: <boss_72_at_yahoo.com>
Date: Thu, 16 Apr 1998 18:10:46 -0600
Message-ID: <6h635m$hsd$1@nnrp1.dejanews.com>

We are running Oracle 8 and have a remote link to via Oracle's transparent gateway to an image database. When doing the following explain:

---SELECT a.deal_id, b.customer_name, a.deal_desc, a.sales_rep_user_id
---FROM OP_Deal a, AMS_Customer_View b WHERE b.op_customer_id
---a.op_customer_id

I get the following plan back filled with these "ERROR: piece-wise fetching" messages. Can someone tell me what might be going on?

QUERY_PLAN                               OBJECT_NOD PARL TEXT


---------------------------------------- ---------- ----


-----------------------

SELECT STATEMENT Cost =
ERROR: piece-wise fetching
  2.1 MERGE JOIN
ERROR: piece-wise fetching

    3.1 SORT (JOIN)

      4.1 REMOTE                         AMSLINK2.W      SELECT
                                         ORLD            OP_CUST_NUM,OP_NAME
                                                         FROM

ORDERP.CUSTOMER_OP
ERROR: piece-wise fetching

    3.2 SORT (JOIN)
ERROR: piece-wise fetching

      4.1 TABLE ACCESS (FULL) OP_DEAL Brian Adams
Dallas, TX

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 16 1998 - 19:10:46 CDT