3 Replies Latest reply: Aug 1, 2013 9:12 AM by 6a10c56d-1620-45fc-b97d-160962627aaa RSS

    I am getting ORA-02063 error while copying bulk data from DBLINK

    6a10c56d-1620-45fc-b97d-160962627aaa

      Hi all ,

       

      I am trying to copy data from DBlink ,whenever i am trying to pull more data ,The db link break down ,

      I have try to put /*+ APPEND */  (Hint) in insert statement.Below is the insert code from my procedure

      from where i am getting below error

       

      "Error in copy_data_pkg-3113 ORA-03113: end-of-file on communication channel

      ORA-02063: preceding line from TESTDBLINK"

       

      Insert code:

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

       

      INSERT /*+ APPEND */ INTO target_tab

      select

      col1,

      col2,

      col3,

      col4,

      col5,

      o_time

      FROM padmin.V_tab1@testdblink

          where

      trunc (sysmodtime) = trunc(sysdate)-1

      and O_time >= al_time

      and (CLEAR_TIME is null or  CLEAR_TIME >= occur_time)

          and (res_code is null or (UPPER(res_code) not LIKE '%TEST TT%' and UPPER(res_code) not LIKE '%TEST SITE%'))

          and ((UPPER(BRIEF_DESC) not like '%TEST TT%' and UPPER(BRIEF_DESC) not LIKE '%TEST SITE%'))

          and (o_time+(330/(24*60))) <= trunc(SYSDATE)-1/24/60/60

          and  catvar IN('POS')

        and UPPER(action_var) not like '%SC_NET%' and UPPER(action) not like '%ROAM_NET%' and UPPER(action) not like '%PUP_NET%';

       

        COMMIT ;

       

      Please suggest me ,why i am getting this error.