ORA-12838: cannot read/modify an object after modifying it in parallel
Hi all, I have something like the script donwhere, and it is throwing me the error I show at the bottom... Anybody can tell me why?? I'm on 11g database, and I believe this used to work in a previous version of the database...
Any fix to make the insert go faster??
keep in mind that in the real process, I have one main cursor and 3 more that feed from that main one.
THANKS!!!!!
declare
cursor c1 is
select 1 from dual
connect by level <= 100000;
begin
for i in c1 loop
insert /*+ APPEND */ into
ale NOLOGGING (value)
values ('1');
end loop;
end;
Error at line 1
ORA-12838: cannot read/modify an object after modifying it in parallel
ORA-06512: at line 12