Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora816/nt bug? pls help!
Which statement is failing ?
"Jan-Erik Rosinowski" <spamfilter_at_rosinowski.de> wrote in message
news:39ba3683.15962793_at_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:56:49 CDT