Yes, there's an article on it at the link below under 'Tips -
Administration' called "How do you drop a column from a table". Interesting
syntax glitch when it comes to dropping multiple columns in one pass. Also
a discussion on the 'set unused' command.
Regards
HJR
--
Oracle Resources : http://www.geocities.com/howardjr2000
========================================
"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:52:23 CST
