Re: Drop a table with foreign key constraints

Hi Uwe,

Thanks for confirming me that this is a good choice.
Yes, I was thinking that this could be also a solution for what I want because 
it is more simple to do.

Octavian

----- Original Message ----- 
From: "Uwe Küchler" <uwe@xxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>; <orasnita@xxxxxxxxx>
Sent: Sunday, August 01, 2010 8:27 PM
Subject: Re: Drop a table with foreign key constraints


> Octavian,
> 
> have you considered using a view as an API to the table? This way, you
> could re-order, rename and even drop columns without caring about FK
> constraints.
> 
> Just trying to K.I.S...
> 
> Regards,
> Uwe
> 
> 
>>
>> From: "Octavian Rasnita" <orasnita@xxxxxxxxx>
>> Subject: Re: Drop a table with foreign key constraints
>> Date: Fri, 30 Jul 2010 22:35:47 +0300
>>   
>>> > The alternative solutionsfor the OP are:
>>> > 
>>> >   - as Dick says, don't bother reorganising columns
>>>     
>> I am storing the balance sheet positions which are displayed in a certain 
>> order, and it would be easier if the table would have them in that order. 
>> And I might need to add some sub-positions in that balance sheet...
>>
>>   
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: