Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ora816/nt bug? pls help!

ora816/nt bug? pls help!

From: Jan-Erik Rosinowski <spamfilter_at_rosinowski.de>
Date: Sat, 09 Sep 2000 13:18:57 GMT
Message-ID: <39ba3683.15962793@News.CIS.DFN.DE>

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

http://www.rsp.de/

rs&p-Dossier: Geschäftsprozeßgesteuerte Schriftguterstellung. Received on Sat Sep 09 2000 - 08:18:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US