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... >> >> > -- //www.freelists.org/webpage/oracle-l