Re: Column Drop

Correction to my previous mail message.

The space freed by a DROP COLUMN command can be reused by Oracle at a later date. My first test was not extensive enough.

Sorry for any misleading,
Andrew

gt_at_uno.com wrote:

> This whole drop column functionality is misleading (especially
> Microsoft's implementation in SQL Server 7).
>
> I still think the temp-table-shuffle is best ( except, of course, a
> better design in the first place).
>
> -Dean
>
> On Wed, 21 Apr 1999 09:47:14 +0800, Andrew Babb <andrewb_at_mail.com>
> wrote:
>
> >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 Sat Apr 24 1999 - 21:37:49 CDT