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 -> QRe: DROP COLUMN Oracle 7.3

QRe: DROP COLUMN Oracle 7.3

From: Bert Scalzo <bscalz01_at_7-11.com>
Date: Fri, 19 Jun 1998 14:46:18 -0500
Message-ID: <6mefd1$69$1@news.ses.cio.eds.com> 





No can do in any version -- this violates ANSI SQL ...



Oracle does sell a product called change management pack that has a utility
to accomplish the end result. It generates all the code to save the old
table's data, drop the old table, create the new table and reload. But that
could take a while for a big table ...


Received on Fri Jun 19 1998 - 14:46:18 CDT












Original text of this message













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