7 Replies Latest reply: Jun 13, 2010 4:12 PM by 779021 RSS

    ORA-12840: cannot access a remote table after parallel/insert direct load

    550030
      Hi,
      I get the following error when running my ETL-Jobs. What' wrong?
      Thanks in advance
      Yvonne

      DWHJob='LIB_CASE_VERSIONS_INSERT'
      Source='"AER"@"ARISG_SOURCE","LIB_CASES"'
      Target='"LIB_CASE_VERSIONS"'
      SumErr='1'
      DateTi='05.01.2007 02:33:38'
      Object='"LIB_CASE_VERSIONS"'
      Stment='TRACE 15: BATCH INSERT'
      SQLErr='-12840'
      ErrMsg='ORA-12840: cannot access a remote table after parallel/insert direct load txn'
      TimeSt='05.01.2007 09:00:47'