Re: Column Drop

From: Andrew Babb <andrewb_at_mail.com>
Date: Wed, 21 Apr 1999 09:47:14 +0800
Message-ID: <371D2E22.2CAB718C@mail.com>

RC,

You are not making sense but, with effect from Oracle8i (v8.1.5) you can logically drop the column from the table, but the space is not freed up for any existing data.

Prior to Oracle8i, there was no way of doing this except for creating the table without the required column and then populating it using INSERT statements.

Andrew

RC wrote:

> Can you drop a column from a table in Oracle 8 ? I know you can do it
> in Oracle 8
Received on Tue Apr 20 1999 - 20:47:14 CDT