Re: Why oracle can't drop column?

From: <jtesta_at_my-dejanews.com>
Date: Tue, 11 Aug 1998 15:39:41 GMT
Message-ID: <6qpoju$dgp$1@nnrp1.dejanews.com>

Oracle will FINALLY implement drop column in 8.1.2 production(i saw it in development). in the mean time, go to http://www.oracle-dba.com and the scripts link and download my drop column pkg.

joe
http://www.oracle-dba.com

In article <35cebf65.3493883_at_news.telecom.pt>, nuno-v-guerreiro_at_telecom.pt (Nuno Guerreiro) wrote:
> On Fri, 31 Jul 1998 16:39:46 +0200, "Jean-Philippe Squelbut"
> <squelbut_at_csi.com> wrote:
>
> >Because, to drop a column will invalidate all the millions of requests of
> >your applications where the column is involved.
>
> So does dropping an entire table. That is surely not an excuse for not
> implementing the RENAME and DROP column features on the Oracle Server
> for all these years.
>
> >You can't rename it (for the same reason).
> >To add a column does not affect the existing requests.
> >Goncharov V a Êcrit dans le message <35C15170.9E9C92CA_at_ftc.ru>...
> >>Hi!
> >>
> >>Why oracle can't drop column?
> >>It can add column and even rename it.
> >>What is sence of this restriction?
> >>Many of RDBMS ca do that.
> >>
>
> I believe it has something to do with data storage - the result would
> produce a highly fragmented table. Perhaps, Oracle will implement the
> DROP feature by creating a new table.
>
> Nuno Guerreiro
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 11 1998 - 10:39:41 CDT