Dear OWM Wizards,
I have made an error in an update trigger during a BeginDDL and CommitDDL session:
-----
exec dbms_wm.BeginDDL('TABLE1');
exec dbms_wm.BeginDDL('TABLE2');
create or replace trigger table1_ut
before update
on table1_lts
for each row
begin
update table2_lts
set ....
end;
exec dbms_wm.CommitDDL('TABLE2');
exec dbms_wm.CommitDDL('TABLE1');
-----
Note the _lts* in the update above.
The last command succeed with complie errors, but left the table in CDDL state.
Using the information
here, I was able to bring the table back into "VERSIONED" state (using ignore_last_error => true in CommitDDL).
Now I have a wm$table1_ut procedure referencing a non-existing table2_lts and am unable to start a ddl session on TABLE1:
-----
$ exec dbms_wm.BeginDDL('TABLE1');
ERROR:
ORA-24344: Erfolg mit Kompilierungsfehler
ORA-06512: in "SYS.OWM_DDL_PKG", Zeile 3200
ORA-06512: in "SYS.LT", Zeile 11857
ORA-06512: in Zeile 1
$ select * from all_wm_vt_errors;
Es wurden keine Zeilen ausgewählt
-----
TABLE1_LTS is not created. And recompiling the procedure does not work, with ORA-20037 attempt to modify a WM generated procedure
What can I do?
Any help appreciated,
Jens
Edited by: user535318 on Aug 14, 2009 5:37 AM