>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 >
Jan,
You do not say which version of Oracle you are using. The facility to drop a
column arrived in Oracle 8i.
HTH,
Rob
Received on Tue Jun 13 2000 - 00:00:00 CDT
