Re: [Fwd: Dropping a column from a table]

Oracle will support drop column from a table in version 8.1, in the mean time, go to http://www.oracle-dba.com and the scripts link and download my drop column pkg, it does it all for you.

joe
http://www.oracle-dba.com

In article <359B7F97.13ECE0F4_at_hrb.com>,   "Kevin J. Kirkpatrick" <kjk_at_hrb.com> wrote:
>
> This is a multi-part message in MIME format.
> --------------F59DE0307406A878949E8137
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> --------------F59DE0307406A878949E8137
> Content-Type: message/rfc822
> Content-Transfer-Encoding: 7bit
> Content-Disposition: inline
>
> Path: zeus.hrb.com!usenet_at_icf.hrb.com
> From: "Kevin J. Kirkpatrick" <kjk_at_hrb.com>
> Newsgroups: comp.databases.oracle
> Subject: Dropping a column from a table
> Date: Thu, 02 Jul 1998 08:15:39 -0400
> Organization: HRB Systems, Inc.
> Message-ID: <359B79EB.8EC3DC53_at_hrb.com>
> NNTP-Posting-Host: ice.hrb.com
> Mime-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> X-Mailer: Mozilla 4.05 [en] (X11; U; SunOS 5.6 sun4u)
>
> I searched everywhere for a way to drop a column from a table but
> couldn't find anything. It would see that you would be able to do it
> with an ALTER TABLE, but there didn't seem to be anything. I devised a
> work around for this problem. Is there another way besides doing this:
>
> This would create a new table minus the column I wanted out:
>
> CREATE TABLE temp_table
> UNRECOVERABLE
> PARALLEL (DEGREE 3)
> AS SELECT name, phone, ssn FROM employee_table;
>
> After that I would drop out employee_table and then recreate it with the
> following:
>
> CREATE TABLE employee_table
> UNRECOVERABLE
> PARALLEL (DEGREE 3)
> AS SELECT * FROM temp_table;
>
> There has got to be an easier way!! Does anyone know it? This worked
> great but I couldn't find any method that explicitly was for this
> dropping columns from a table.
>
> Kevin
>
> --------------F59DE0307406A878949E8137--
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 02 1998 - 12:07:21 CDT