From: spamfilter@rosinowski.de (Jan-Erik Rosinowski)
Newsgroups: comp.databases.oracle.server
Subject: ora816/nt bug? pls help!
Date: Sat, 09 Sep 2000 13:18:57 GMT
Organization: rs&p GmbH
Lines: 55
Message-ID: <39ba3683.15962793@News.CIS.DFN.DE>
Reply-To: spamfilter@rosinowski.de
NNTP-Posting-Host: p3ee0a88f.dip0.t-ipconnect.de (62.224.168.143)
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: fu-berlin.de 968505490 13346721 62.224.168.143 (16 [7082])
X-Newsreader: Forte Agent 1.5/32.452


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.