Re: ora816/nt bug? pls help!

I can only confirm that the script results in the same error on a similar nt test environment that I have access to.

However, if I dropped either the tbd_master trigger or the tad_master trigger, the delete succeeded. These, however, may not be acceptable workarounds.

Experimenting long enough resulted in an ora-01092 "Oracle instance terminated. Disconnection forced" message. Then I had to stop and restart the services to make a connection even as sysdba.

Frank Hubeny

Jan-Erik Rosinowski wrote:

> 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 - 16:11:33 CDT