Re: Dropping columns in 8.04? Or 8.15 ie 8i?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 21 Apr 1999 09:18:14 -0700
Message-ID: <371DFA46.B9148B27@us.oracle.com>

Conrad

It's a feature that came only in 8i. Earlier releases did not have this command. There were a number of ways people got around this:

Recreate the table without the column
Use a third party tool to automate approach 1
Create a view over the top of the table without the column.

HTH. Pete

Acorn wrote:

> Does anyone know if 8.04 allows 'alter table drop column', I only see 8i
> allowing this. Has anyone else run into this problem?
>
> Thanks in advance!
> Conrad

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Apr 21 1999 - 11:18:14 CDT