Re: How to drop a column?

A copy of this was sent to "Dave Butler" <butlerdi_at_otuk.co.uk> (if that email address didn't require changing) On Fri, 15 Oct 1999 12:17:14 +0100, you wrote:

>Oracle 8.1.5 does allow this, but only 1 at a time......
>

Oracle8i, release 8.1 allows you to mark MANY columns as unused (they 'disappear' when marked unused) and then drop all unused columns (physically rewrites the table to reclaim the space)..

It lets you drop as many columns at a time as you want..

>-----Original Message-----
>From: QuestionExchange <usenet_at_questionexchange.com>
>To: comp.databases.oracle.misc_at_list.deja.com
><comp.databases.oracle.misc_at_list.deja.com>
>Date: Friday, October 15, 1999 12:14 PM
>Subject: Re: How to drop a column?
>
>
>> Message from the Deja.com forum:
>> comp.databases.oracle.misc
>> Your subscription is set to individual email delivery
>>>
>>> Has oracle provide any ways to drop a column in a table?
>>> thanks in advance.
>>>
>>No, Oracle does not provide a way, but look at the
>>following URL for a solution and 2 work-arounds:
>> http://www.orafaq.org/faqsql.htm#DROPCOL
>>Hope this helps!
>>
>>--
>> This answer is courtesy of QuestionExchange.com
>>
>http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=4887&cus_id=USE
>NET&qtn_id=4015
>>
>>
>>
>> _____________________________________________________________
>> Deja.com: Before you buy.
>> http://www.deja.com/
>> * To modify or remove your subscription, go to
>> http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.misc
>> * Read this thread at
>> http://www.deja.com/thread/%3C1577qx%40questionexchange.com%3E
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Oct 15 1999 - 07:42:06 CDT