Re: ON DELETE CASCADE

On the plus side, you can enable it in an non-validated state, then validate it. (8.1) This means you do not lock the tables for the duration of the validation phase.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Sybrand Bakker wrote in message
<954859073.16528.0.pluto.d4ee154e_at_news.demon.nl>...
>drop the constraint and recreate it. There's no other way, sorry.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>wolfgang karrer <wolfgang.karrer_at_ce.uni-linz.ac.at> wrote in message
>news:38e9d7b0_at_alijku02.edvz.uni-linz.ac.at...
>> Hi everyone,
>>
>>
>> how is it possible to change a foreign key constraint to do the on delete
>> cascade?
>>
>> CREATE TABLE Verfahren
>> (verfahrenNr INTEGER PRIMARY KEY,
>> bezeichnung VARCHAR2(50) NOT NULL,
>> beschreibung VARCHAR2(500),
>> ziel VARCHAR2(500),
>> datumerstellt DATE,
>> erhebNr INTEGER NOT NULL,
>> CONSTRAINT erhebNr_verfahren FOREIGN KEY (erhebNr) REFERENCES
>> ERHEBUNGSMETHODE (erhebNr));
>>
>> This is the table i created for a few years. Now i want to add a on
delete
>> cascade to the constraint erhebnr_verfahren. How is this possible?
>>
>> ALTER TABLE Verfahren modify ...
>>
>> Thanks a lot
>>
>>
>>
>> --
>> Wolfgang Karrer
>> Büro für EDV-Dienstleistungen
>> Gewerbegasse 6
>> 4060 Leonding
>> Tel + Fax. (0732) 681795
>> Mobil: (0699) 134 18 469
>> EMail: w.karrer_at_ooenet.at
>> ---------------------------------------
>> Institut für Wirtschaftsinformatik
>> Abteilung Communications Engineering
>> o.Univ.- Prof. DI Dr. Christian Stary
>> Freistädterstr. 315
>> 4040 Linz/Urfahr
>> Tel: (0732) 2468-7112
>> EMail: wolfgang.karrer_at_ce.uni-linz.ac.at
>>
>>
>>
>
>
Received on Tue Apr 04 2000 - 14:00:02 CDT