Re: Alter referential constraint...

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 19 Aug 2005 20:01:03 +0200
Message-ID: <hh7cg1ho21gh4h412tn29k3j338cb3hupv@4ax.com>

On Fri, 19 Aug 2005 15:55:42 GMT, netcomradeNSPAM_at_bookexchange.net (NetComrade) wrote:

>Is there are a way to alter constraint so that it doesn't cascade
>deletes?
>
>Thanks.
>.......
>We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
>remove NSPAM to email

As the default is on delete restrict drop and recreate it is in order, at least on 8i.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Aug 19 2005 - 13:01:03 CDT

This message: [ Message body ]
Next message: DonBurlesonIsASackOfManur: "Be an ontruder: Intrude on Oracle panties the OMLETiclios way, the front door!"
Previous message: mnguice_at_gmail.com: "Re: negative IO numbers when viewing Cumulative IO with OEM"
In reply to: NetComrade: "Alter referential constraint..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US