Import create duplicate records

From: Gavin Lee <sting08_at_pd.jaring.my>
Date: Thu, 16 Aug 2001 22:54:52 +0800
Message-ID: <9lgmdm$jkq$1@news6.jaring.my>

Hi follks

    I encounter duplicate records when the records import is more than 150 records. Please advise.

oracle 7.3.4
Database A temporary table: trfr_stock_orders trigger: tso_insert insert into – stk_order_headers, stk_order_details synonym stk_order_headers_at_databaseB
synonym stk_order_details_at_databaseB

Database B tables : stk_order_headers, stk_order_details

Trace while import file contain 150 records - no duplicate SELECT TSO.LOC_CD,LOC.DB_NAME,INDENT_FLG FROM
TRFR_STOCK_ORDERS TSO,LOCATIONS LOC WHERE TSO.TRF_STATUS IS NULL AND TSO.ACCT_TYPE IN ( 'EP','HP' ) AND TSO.LOC_CD = LOC.LOC_CD GROUP BY TSO.LOC_CD,LOC.DB_NAME,INDENT_FLG call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 25 0.00 0.00 15 18 4 24
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 27 0.00 0.00 15 18 4 24
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 14 (RACDBA) (recursive depth: 1) Rows Execution Plan

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

0 SELECT STATEMENT GOAL: CHOOSE
149 SORT (GROUP BY)
149 HASH JOIN
150 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'TRFR_STOCK_ORDERS' 335 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'LOCATIONS'

---

Trace while import file contain 171 records - total records created 339. SELECT TSO.LOC_CD,LOC.DB_NAME,INDENT_FLG FROM
TRFR_STOCK_ORDERS TSO,LOCATIONS LOC WHERE TSO.TRF_STATUS IS NULL AND TSO.ACCT_TYPE IN ( 'EP','HP' ) AND TSO.LOC_CD = LOC.LOC_CD GROUP BY TSO.LOC_CD,LOC.DB_NAME,INDENT_FLG call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 17 257 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 52 0.00 0.00 15 39 8 50
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 55 0.00 0.00 32 296 8 50
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 14 (RACDBA) (recursive depth: 1) Rows Execution Plan

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

0 SELECT STATEMENT GOAL: CHOOSE
337 SORT (GROUP BY)
337 HASH JOIN
339 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'TRFR_STOCK_ORDERS' 670 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'LOCATIONS'

---

Thanks & Regards
gavin Received on Thu Aug 16 2001 - 09:54:52 CDT