Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Are the Triggers, Constraints .... getting killed too ??
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