Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Stupid trigger problem
The following trigger give me a compilation error but I don't know why:
create trigger tr delete or insert on testtab
BEGIN
alter index testtabidx rebuild online parameters('sync');
end;
/
also
create trigger tr delete or insert on testtab
BEGIN
execute immediate alter index testtabidx rebuild online parameters('sync');
end;
/
did not work. Any idea ?
Thanks, Received on Fri Jul 28 2000 - 04:38:20 CDT
![]() |
![]() |