Oracle Database Discussions

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