Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Are the Triggers, Constraints .... getting killed too ??

Re: Are the Triggers, Constraints .... getting killed too ??

From: michael.kurz <michael.kurz_at_metronet.de>
Date: Tue, 29 Dec 1998 14:48:38 +0100
Message-ID: <76amhk$37c$1@news.metronet.de>


Hai Connor McDonald

This is as Great solution !!!

Thanx
Micha

Connor McDonald schrieb in Nachricht <3688C443.E83_at_bhp.com.au>...
>michael.kurz wrote:
>>
>> Hai Diane and Zoltan
>>
>> Thanx for your quick answer !
>>
>> If I drop the Table and recreate it
>> are then the Triggers, Constraints .... getting killed too ??
>>
>> Or are they still there ??
>>
>> Happy New Year :-)
>>
>> Micha
>
>A quick and dirty way so that you do not have to recreate all of your
>grants/triggers etc is to:
>
>rename original_table to original_table_secret;
>
>create view original_table as
>select "all columns except dropped one"
>from original_table_secret;
>
>HTH
>--
>==============================================
>Connor McDonald
>BHP Information Technology
>Perth, Western Australia
>"The difference between me and a madman is that I am not mad"
> - Salvador Dali
Received on Tue Dec 29 1998 - 07:48:38 CST

Original text of this message

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