Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ora816/nt bug? pls help!
hi,
when i execute the following code against our oracle 8.1.6/nt test-db (original starter-db-configuration) it exits with an ora-03113. no dumps are written. anybody any idea?
#####
drop table demo.t_detail;
create table demo.t_detail (
dokumentid number(11, 0) not null
);
drop table demo.t_master;
create table demo.t_master (
dokumentid number(11, 0) not null
);
alter table demo.t_master add constraint did primary key (
dokumentid
);
alter table demo.t_detail add constraint fk_did foreign key(
dokumentid
) references demo.t_master(
dokumentid
) on delete cascade;
create trigger demo.tad_detail after delete on demo.t_detail
begin
null;
end;
/
create trigger demo.tad_master after delete on demo.t_master
begin
null;
end;
/
create trigger demo.tbd_master before delete on demo.t_master
begin
null;
end;
/
delete from demo.t_master where 0=1;
#####
i tried to contact metalink.oracle.com but although i seem to be registered i cannot submit any bugreport :-(
ciao, jan
rs&p-Dossier: Geschäftsprozeßgesteuerte Schriftguterstellung. Received on Sat Sep 09 2000 - 08:18:57 CDT