Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Why oracle can't drop column?

Re: Why oracle can't drop column?

From: Jean-Philippe Squelbut <squelbut_at_csi.com>
Date: Fri, 31 Jul 1998 16:39:46 +0200
Message-ID: <uYKy7EJv9GA.288@nih2naac.prod2.compuserve.com>


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
Received on Fri Jul 31 1998 - 09:39:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US