merge
        into goods t
        using gift.goods@office_vpn s
        on (t.id=s.id)
        when matched then update set 
            t.name=s.name, t.name_uc=s.name_uc, t.producerid=s.producerid, t.taxid=s.taxid, t.goodstypeid=s.goodstypeid, t.goodsgroupid=s.goodsgroupid, t.dimensionid=s.dimensionid, t.price_regulation=s.price_regulation, 
            t.pricegroupid=s.pricegroupid, t.regno=s.regno, t.regdate=s.regdate, t.regexpired=s.regexpired, t.barcode=s.barcode, t.storagecondid=s.storagecondid, t.kratn=s.kratn, t.disable=s.disable, t.isrecept=s.isrecept, 
            t.national_list=s.national_list, t.min_assort=s.min_assort, t.isjob=s.isjob, t.uktz=s.uktz, t.isaplan=s.isaplan, t.bonus_id=s.bonus_id, t.bonus_fixed=s.bonus_fixed, t.bonus_percent=s.bonus_percent, 
            t.release_form_id=s.release_form_id, t.comments=s.comments, t.age=s.age, t.contraindication=s.contraindication, t.tabletki_href=s.tabletki_href, t.compendium_href=s.compendium_href, t.other_href=s.other_href, 
            t.method_of_application=s.method_of_application, t.benefits=s.benefits, t.dose=s.dose, t.capacity_num=s.capacity_num, t.analog_goodsid_by_nds=s.analog_goodsid_by_nds, t.goodsimagesid=s.goodsimagesid, 
            t.elementsinoneitem=s.elementsinoneitem, t.isgetndsfromgoods=s.isgetndsfromgoods, t.maxcountfromonesale=s.maxcountfromonesale 
            where id<>-1
        when not matched then insert 
            (t.id, t.name, t.name_uc, t.producerid, t.taxid, t.goodstypeid, t.goodsgroupid, t.dimensionid, t.price_regulation, t.pricegroupid, t.regno, t.regdate, t.regexpired, t.barcode, t.storagecondid, 
            t.kratn, t.disable, t.isrecept, t.national_list, t.min_assort, t.isjob, t.uktz, t.isaplan, t.bonus_id, t.bonus_fixed, t.bonus_percent, t.release_form_id, t.comments, t.age, t.contraindication, 
            t.tabletki_href, t.compendium_href, t.other_href, t.method_of_application, t.benefits, t.dose, t.capacity_num, t.analog_goodsid_by_nds, t.goodsimagesid, t.elementsinoneitem, t.isgetndsfromgoods, t.maxcountfromonesale
            ) values (
            s.id, s.name, s.name_uc, s.producerid, s.taxid, s.goodstypeid, s.goodsgroupid, s.dimensionid, s.price_regulation, s.pricegroupid, s.regno, s.regdate, s.regexpired, s.barcode, s.storagecondid, 
            s.kratn, s.disable, s.isrecept, s.national_list, s.min_assort, s.isjob, s.uktz, s.isaplan, s.bonus_id, s.bonus_fixed, s.bonus_percent, s.release_form_id, s.comments, s.age, s.contraindication, 
            s.tabletki_href, s.compendium_href, s.other_href, s.method_of_application, s.benefits, s.dose, s.capacity_num, s.analog_goodsid_by_nds, s.goodsimagesid, s.elementsinoneitem, s.isgetndsfromgoods, s.maxcountfromonesale
            )

merge 
    into goods t
    using (select /*+ DRIVING_SITE(o) */ * from gift.goods@office_vpn o) s
    on (t.id=s.id)
    when matched then update set 
        t.name=s.name, t.name_uc=s.name_uc, t.producerid=s.producerid, t.taxid=s.taxid, t.goodstypeid=s.goodstypeid, t.goodsgroupid=s.goodsgroupid, t.dimensionid=s.dimensionid, t.price_regulation=s.price_regulation, 
        t.pricegroupid=s.pricegroupid, t.regno=s.regno, t.regdate=s.regdate, t.regexpired=s.regexpired, t.barcode=s.barcode, t.storagecondid=s.storagecondid, t.kratn=s.kratn, t.disable=s.disable, t.isrecept=s.isrecept, 
        t.national_list=s.national_list, t.min_assort=s.min_assort, t.isjob=s.isjob, t.uktz=s.uktz, t.isaplan=s.isaplan, t.bonus_id=s.bonus_id, t.bonus_fixed=s.bonus_fixed, t.bonus_percent=s.bonus_percent, 
        t.release_form_id=s.release_form_id, t.comments=s.comments, t.age=s.age, t.contraindication=s.contraindication, t.tabletki_href=s.tabletki_href, t.compendium_href=s.compendium_href, t.other_href=s.other_href, 
        t.method_of_application=s.method_of_application, t.benefits=s.benefits, t.dose=s.dose, t.capacity_num=s.capacity_num, t.analog_goodsid_by_nds=s.analog_goodsid_by_nds, t.goodsimagesid=s.goodsimagesid, 
        t.elementsinoneitem=s.elementsinoneitem, t.isgetndsfromgoods=s.isgetndsfromgoods, t.maxcountfromonesale=s.maxcountfromonesale 
        where id<>-1
    when not matched then insert 
        (t.id, t.name, t.name_uc, t.producerid, t.taxid, t.goodstypeid, t.goodsgroupid, t.dimensionid, t.price_regulation, t.pricegroupid, t.regno, t.regdate, t.regexpired, t.barcode, t.storagecondid, 
        t.kratn, t.disable, t.isrecept, t.national_list, t.min_assort, t.isjob, t.uktz, t.isaplan, t.bonus_id, t.bonus_fixed, t.bonus_percent, t.release_form_id, t.comments, t.age, t.contraindication, 
        t.tabletki_href, t.compendium_href, t.other_href, t.method_of_application, t.benefits, t.dose, t.capacity_num, t.analog_goodsid_by_nds, t.goodsimagesid, t.elementsinoneitem, t.isgetndsfromgoods, t.maxcountfromonesale
        ) values (
        s.id, s.name, s.name_uc, s.producerid, s.taxid, s.goodstypeid, s.goodsgroupid, s.dimensionid, s.price_regulation, s.pricegroupid, s.regno, s.regdate, s.regexpired, s.barcode, s.storagecondid, 
        s.kratn, s.disable, s.isrecept, s.national_list, s.min_assort, s.isjob, s.uktz, s.isaplan, s.bonus_id, s.bonus_fixed, s.bonus_percent, s.release_form_id, s.comments, s.age, s.contraindication, 
        s.tabletki_href, s.compendium_href, s.other_href, s.method_of_application, s.benefits, s.dose, s.capacity_num, s.analog_goodsid_by_nds, s.goodsimagesid, s.elementsinoneitem, s.isgetndsfromgoods, s.maxcountfromonesale
        );

Plan hash value: 1483448804
 
---------------------------------------------------------------------------------------------------------
| Id  | Operation               | Name  | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     | Inst   |IN-OUT|
---------------------------------------------------------------------------------------------------------
|   0 | MERGE STATEMENT         |       | 51798 |   395M|       |  3972   (1)| 00:00:48 |        |      |
|   1 |  MERGE                  | GOODS |       |       |       |            |          |        |      |
|   2 |   VIEW                  |       |       |       |       |            |          |        |      |
|*  3 |    HASH JOIN RIGHT OUTER|       | 51798 |    48M|    18M|  3972   (1)| 00:00:48 |        |      |
|   4 |     TABLE ACCESS FULL   | GOODS | 51840 |    17M|       |   827   (1)| 00:00:10 |        |      |
|   5 |     REMOTE              | GOODS | 51798 |    30M|       |   689   (2)| 00:00:09 | OFFIC~ | R->S |
---------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("T"."ID"(+)="S"."ID")
 
Remote SQL Information (identified by operation id):
----------------------------------------------------
 
   5 - SELECT "ID","NAME","BARCODE","BARCODEEXT","REGNO","REGDATE","REGEXPIRED","ISJOB","DISABLE"
       ,"PRICEGROUPID","PRODUCERID","TAXID","GOODSTYPEID","DIMENSIONID","STORAGECONDID","GOODSGROUPID","
       ARTICLE","ISAPLAN","ISGROUP","GROUPID","ORDERBOX","DAYPRESENT","DAYABSENT","QTYCURS","QTYSALES","
       QTYSALES30","QTYSALES14","QTYIN","QTYREST","QTYLEFT","QTYINWAY","QTYPASS","QTYNEEDS","QTYORDER","
       SUMSALES","SUMWEEK","PRICE","SALESGROUP","MORIONID","MORIONNAME","CREATORID","CREATEDATE","COMMEN
       TS","UPDATEDDATE","PRICE0","PRICE1","PRICE2","PRICE3","PRICE4","PRICE5","PRICE6","LASTPRICE0","LA
       STPRICE1","LASTPRICE6","GOODSIMAGESID","PRICE_REGULATION","KRATN","RATING","MAINVENDORID","NOTUSE
       INTBARCODE","NOTUSEFACTBARCODE","SALESGROUPA","SALESGROUPB","ZAKLTXT","ZAKLDATE","ZAKLEXPIRED","C
       OLORID","SIZEID","STRUCTUREID","CAPACITY","ARTNAME","ISRECEPT","MAXPRICE","MARGINE","ISWEIGTH","P
       LUCODE","NO_PRINT_STICKER_BARCODE","UKTZ","ISBUDGET","ISTRANSIT","DEFSTICKERSCNT","TMAX","TMIN","
       SVET","DOSE","RELEASE_FORM_ID","CAPACITY_NUM","PRICEREF","NATIONAL_LIST","MIN_ASSORT","LAST_VENDO
       R_ID","SIGNEDBY","METHOD_OF_APPLICATION","BENEFITS","BONUS_ID","BONUS_FIXED","BONUS_PERCENT","WHO
       LESALEPRICE","ISNOSHARE","GOODSNAME_ID","RELEASEFORM","LIMITSALE","TURNOVER","KRATN_ORDER","OWNER
       ID","NAME_BK","PRODUCER_BK","ID_BK","LASTPRICE1_MAINVENDOR","PRICE_SEGMENTS_ID","LAST_CONTRACT_ID
       ","XYZ_TOTAL","XYZ","XYZ_QTYRATIO","XYZ_SUM2RATIO","XYZ_MARGINRATIO","XYZ_MARGIN","PROMOUTERID","
       MARKET_PRIORITY","MARKET_SIPPRICE","MARKET_BONUS_PERCENT","MARKET_BONUS_SUMMA","ANALOG_GOODSID_BY
       _NDS","NOTZAKAZFROMSUPPLIERS","ISNOTINTERNET","ISPRICE6INTERNET","CONTRAINDICATION","AGE","MARGIN
       FORINTERNET","ELEMENTSINONEITEM","MARKET_PACKET","TABLETKI_HREF","COMPENDIUM_HREF","OTHER_HREF","
       SUMREST","MINPRICE6","NAME_UC","ISGETNDSFROMGOODS","MAXCOUNTFROMONESALE" FROM "GIFT"."GOODS" "S" 
       (accessing 'OFFICE_VPN' )
 

Plan hash value: 1483448804
 
---------------------------------------------------------------------------------------------------------
| Id  | Operation               | Name  | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     | Inst   |IN-OUT|
---------------------------------------------------------------------------------------------------------
|   0 | MERGE STATEMENT         |       | 51798 |   395M|       |  4275   (1)| 00:00:52 |        |      |
|   1 |  MERGE                  | GOODS |       |       |       |            |          |        |      |
|   2 |   VIEW                  |       |       |       |       |            |          |        |      |
|*  3 |    HASH JOIN RIGHT OUTER|       | 51798 |    48M|    19M|  4275   (1)| 00:00:52 |        |      |
|   4 |     TABLE ACCESS FULL   | GOODS | 51808 |    18M|       |  1100   (1)| 00:00:14 |        |      |
|   5 |     REMOTE              | GOODS | 51798 |    30M|       |   689   (2)| 00:00:09 | OFFIC~ | R->S |
---------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("T"."ID"(+)="S"."ID")
 
Remote SQL Information (identified by operation id):
----------------------------------------------------
 
   5 - SELECT "ID","NAME","BARCODE","BARCODEEXT","REGNO","REGDATE","REGEXPIRED","ISJOB","DISABLE"
       ,"PRICEGROUPID","PRODUCERID","TAXID","GOODSTYPEID","DIMENSIONID","STORAGECONDID","GOODSGROUPID","
       ARTICLE","ISAPLAN","ISGROUP","GROUPID","ORDERBOX","DAYPRESENT","DAYABSENT","QTYCURS","QTYSALES","
       QTYSALES30","QTYSALES14","QTYIN","QTYREST","QTYLEFT","QTYINWAY","QTYPASS","QTYNEEDS","QTYORDER","
       SUMSALES","SUMWEEK","PRICE","SALESGROUP","MORIONID","MORIONNAME","CREATORID","CREATEDATE","COMMEN
       TS","UPDATEDDATE","PRICE0","PRICE1","PRICE2","PRICE3","PRICE4","PRICE5","PRICE6","LASTPRICE0","LA
       STPRICE1","LASTPRICE6","GOODSIMAGESID","PRICE_REGULATION","KRATN","RATING","MAINVENDORID","NOTUSE
       INTBARCODE","NOTUSEFACTBARCODE","SALESGROUPA","SALESGROUPB","ZAKLTXT","ZAKLDATE","ZAKLEXPIRED","C
       OLORID","SIZEID","STRUCTUREID","CAPACITY","ARTNAME","ISRECEPT","MAXPRICE","MARGINE","ISWEIGTH","P
       LUCODE","NO_PRINT_STICKER_BARCODE","UKTZ","ISBUDGET","ISTRANSIT","DEFSTICKERSCNT","TMAX","TMIN","
       SVET","DOSE","RELEASE_FORM_ID","CAPACITY_NUM","PRICEREF","NATIONAL_LIST","MIN_ASSORT","LAST_VENDO
       R_ID","SIGNEDBY","METHOD_OF_APPLICATION","BENEFITS","BONUS_ID","BONUS_FIXED","BONUS_PERCENT","WHO
       LESALEPRICE","ISNOSHARE","GOODSNAME_ID","RELEASEFORM","LIMITSALE","TURNOVER","KRATN_ORDER","OWNER
       ID","NAME_BK","PRODUCER_BK","ID_BK","LASTPRICE1_MAINVENDOR","PRICE_SEGMENTS_ID","LAST_CONTRACT_ID
       ","XYZ_TOTAL","XYZ","XYZ_QTYRATIO","XYZ_SUM2RATIO","XYZ_MARGINRATIO","XYZ_MARGIN","PROMOUTERID","
       MARKET_PRIORITY","MARKET_SIPPRICE","MARKET_BONUS_PERCENT","MARKET_BONUS_SUMMA","ANALOG_GOODSID_BY
       _NDS","NOTZAKAZFROMSUPPLIERS","ISNOTINTERNET","ISPRICE6INTERNET","CONTRAINDICATION","AGE","MARGIN
       FORINTERNET","ELEMENTSINONEITEM","MARKET_PACKET","TABLETKI_HREF","COMPENDIUM_HREF","OTHER_HREF","
       SUMREST","MINPRICE6","NAME_UC","ISGETNDSFROMGOODS","MAXCOUNTFROMONESALE" FROM "GIFT"."GOODS" "S" 
       (accessing 'OFFICE_VPN' )