5 Replies Latest reply: Dec 8, 2009 9:15 AM by Nicolas.Gasparotto RSS

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

    609621
      insert /*+ append parallel nologging */ into temp_tbl select d_duration,cduration from tstrtw i , medt_faml f
      where tdate >= '01-sep-09' and tdate <'01-oct-09'
      and ttype = '001'
      and subsequip_tno = i.tno
      and f.b_tno = f.b_tno
      and equipid ='BESTFR'


      when am running this query : am getting the error :

      ERROR at line 1:
      ORA-12840: cannot access a remote table after parallel/insert direct load txn



      I checked the following :


      a) using the query ,
      select t.start_time,s.sid,s.serial#,s.username,s.status,s.schemaname,
      s.osuser,s.process,s.machine,s.terminal,s.program,s.module,to_char(s.logon_time,'DD/MON/YY HH24:MI:SS') logon_time
      from v$transaction t, v$session s
      where s.saddr = t.ses_addr
      order by start_time;

      there are no dml's going on this tables tstrtw i and medt_faml f


      b) checked notes [ID 49056.1] and [ID 292442.1].


      helpless.. any idea ?



      table tstrtw is a remote table


      TIA


      Kai