From: "Adrian Shepherd" <theshepherds@hotmail.com>
Newsgroups: comp.databases.oracle.server
References: <39ba3683.15962793@News.CIS.DFN.DE>
Subject: Re: ora816/nt bug? pls help!
Lines: 61
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <Bkru5.1470$tj4.16613@news-server.bigpond.net.au>
Date: Sat, 09 Sep 2000 13:56:49 GMT
NNTP-Posting-Host: 144.132.45.148
X-Complaints-To: news@bigpond.net.au
X-Trace: news-server.bigpond.net.au 968507809 144.132.45.148 (Sun, 10 Sep 2000 00:56:49 EST)
NNTP-Posting-Date: Sun, 10 Sep 2000 00:56:49 EST
Organization: BigPond Internet Services (http://www.bigpond.net.au)


Which statement is failing ?

"Jan-Erik Rosinowski" <spamfilter@rosinowski.de> wrote in message
news: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.