Re: Oracle 8i with Column Delete

Hi Steve,

You can in 8.1.5.0.0 So I suppose it should be possible in 8.1.6+.. Use ALTER TABLE tablename DROP COLUMN columnname;

Regards,
Bliss
"Steve" <schen_at_prodigy.net> wrote in message news:uTfE7.12995$bH1.2142310421_at_newssvr15.news.prodigy.com...
> Hi,
>
> Does anyone knows whether Oracle 8i (816+) can delete column directly
> instead of using imp/exp?
>
> Thanks,
>
> Steve
>
>
Received on Thu Nov 01 2001 - 12:10:33 CST