Re: Removing a column from a table?

From: Holger Heidenbluth <heidenbluth_at_nis-rheinsberg.de>
Date: 2000/06/16
Message-ID: <8idcdf$2h5$1@wrath.news.nacamar.de>#1/1

KeepTool (www.keeptool.com) can drop
columns in databases from 7.3 up to 8i.

Regards Holger Heidenbluth

Jan Kim <kim_at_jupiter.mpiz-koeln.mpg.de> schrieb in im Newsbeitrag: 8i6b47$fvb$1_at_gwdu67.gwdg.de...
> Dear Oraclers,
>
> is it possible to remove a column from a table? In other words, is there
> a command to undo the effect of
>
> ALTER TABLE mytable ADD superfluous_column INT;
>
> As an alternative, is there a way to convince the ``imp'' program not
> to insist on creating the superfluous_column, even though it is in the
> dump file?
>
> Greetinx & thanx in advance, Jan
> --
> +- Jan T. Kim -------------------------------------------------------+
> | email: kim_at_mpiz-koeln.mpg.de |
> | WWW: http://www.mpiz-koeln.mpg.de/~kim/ |
> *-----=< hierarchical systems are for files, not for humans >=-----*
Received on Fri Jun 16 2000 - 00:00:00 CDT