INSERT OVER DB LINK IS VERY SLOW AND HANGS UP

Trying to Insert  244,455 record over a DB link. It just runs and hangs. Tried using Hints(Append) and it dint help. DO we need cursor? Not sure if something with Gather Schema Stats

Any Suggestions is appreciated?

 INSERT /*+ append */ INTO TABLE1    (    CUSTOMER_NAME,    ORG,    MARKET_TYPE,    SUB_MARKET_TYPE,    CUST_CLASS,    HEADER_ID,    CONTRACT_NUMBER,    LINE_NUMBER,    SHIP_ACCOUNT_NUMBER,    BILL_TO_ACCOUNT_NAME,    BILL_TO_ACCOUNT_NUMBER,    BILL_CONTACT_NAME,    BILL_CONTACT_EMAIL,    SHIP_ACCOUNT_NAME,    SHIP_CONTACT_NAME,    SHIP_CONTACT_EMAIL,    CUST_PO_NUMBER_REQ_YN,    SITE_DEPT,    SHIP_TO_ADDRESS1,    SHIP_TO_ADDRESS2,    SHIP_TO_CITY,    SHIP_TO_STATE,    SHIP_TO_PROVINCE,    SHIP_TO_COUNTY,    SHIP_TO_ZIP_CODE,    COUNTRY,     SHIP_TO_COUNTRY,     BUSINESS_UNIT,    PRODUCTFAMILY,     ITEM,    ITEM_DESCRIPTION,    SUB_START_DATE,    START_DATE_FORMATED,    SUB_END_DATE,    END_DATE_FORMATED,    INVOICE_CURRENCY_CODE,    GROSS_PRICE,    EXCHANGE_RATE,    BATCH_NUMBER,    RENEWAL_NOTICE_NO,    TERMINATION_REASON,    STATUS_CHANGE_REASON,    CREATED_DATE,    DATE_APPROVED,     STS_CODE,    SHIP_TO_LOCATION,    INVOICE_DATE,    INVOICE_NUMBER,    US_INTERNATIONAL,     SPLIT_PERCENT,    FINAL_PRICE_IN_USD_GROSS,    COMMISSION_GROUP,    AM_RESOURCE_NAME,    TERRITORY_CODE,    PRECEDENCE,    HDR_PO_NUMBER,    LINE_PO_NUMBER,     RENEWED_UP_TO,    ORD_PRD_TOTAL,    LAST_YEAR_GROSS_PRICE,    LAST_YEAR_DURATION,    SUPPRESS_RENEWALS,    ORDER_HOLD,    ORDER_TYPE,    PRIOR_NEW_RENEW,    AUTO_RENEW,     RENEWAL_TO_CONTACT,     RENEWAL_CONTACT_EMAIL,    INVOICE_TO_CONTACT,    INVOICE_CONTACT_EMAIL,    REN_OPT_OUT,    INV_OPT_OUT,    QUANTITY,    RETURN_ATTRIBUTE1,    RENEWAL_GROUP,    PUBLICATION_DATES,     SHIPPING,    TAX_VALUE,     FORMAT,    UPGRADE_TYPE,    ACCT_RULE_START_DATE,    SP_RESOURCE_NAME,