Re: Why oracle can't drop column?

In version 8.1.2-development, you can do it, when it will come to production for sure is probably in 8.1.X, but we will have to wait and see. in the mean time, go to http://www.oracle-dba.com scripts link and download my drop column package, it does all the dirty work for you(and yes the source code for it is there also).

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

In article <6psviq$2fg1_at_news.hk.linkage.net>,   "Rob Edgar" <robedgar_at_mersey.com.hk> wrote:
> Well you can drop and recreate the table without the offending column and
> your application will still send in its millions of invalid requests, so I
> dont think thats the reason why you cant do it <g>
>
> IMHO the reason is connected with data storage, you can always add columns
> as you can make more space available at worst by chaining the row BUT to
> remove a column from the middle of a row would leave a hole in it so you are
> required to drop and rebuild the table which result in a nice new table with
> no black holes....
>
> Minor point as the end result is the same<g>
>
> Rob
>
> Jean-Philippe Squelbut wrote in message ...
> >Because, to drop a column will invalidate all the millions of requests of
> >your applications where the column is involved.
> >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.
> >>
> >>Best regard. Vovva
> >
> >
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 03 1998 - 08:48:34 CDT