Xref: alice comp.databases.oracle.misc:56684 Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!skynet.be!dispose.news.demon.net!demon!news.demon.co.uk!demon!jlcomp.demon.co.uk!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.misc Subject: Re: ON DELETE CASCADE Date: Tue, 4 Apr 2000 20:00:02 +0100 Message-ID: <954876199.1778.0.nnrp-09.9e984b29@news.demon.co.uk> References: <38e9d7b0@alijku02.edvz.uni-linz.ac.at> <954859073.16528.0.pluto.d4ee154e@news.demon.nl> X-Trace: news.demon.co.uk 954876199 nnrp-09:1778 NO-IDENT jlcomp.demon.co.uk:158.152.75.41 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 70 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@news.demon.nl>... >drop the constraint and recreate it. There's no other way, sorry. > >Hth, > >Sybrand Bakker, Oracle DBA > >wolfgang karrer wrote in message >news:38e9d7b0@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@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@ce.uni-linz.ac.at >> >> >> > >