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

go to http://www.oracle-dba.com and get my drop column pkg.

click on the scripts link

joe

In article <359B926B.6BC5_at_ictgroup.com>,   jgitomer_at_ictgroup.com wrote:
>
> Hi Kevin,
>
> You couldn't find it because it doesn't exist. Although I think you
> took the best alternative in creating a new table another alternative to
> consider is to create a view that doesn't include the column you want
> dropped.
>
> Jerry
>
> Kevin J. Kirkpatrick wrote:
> >
> >
> >
> > ---------------------------------------------------------------
> >
> > Subject: Dropping a column from a table
> > Date: Thu, 02 Jul 1998 08:15:39 -0400
> > From: "Kevin J. Kirkpatrick" <kjk_at_hrb.com>
> > Organization: HRB Systems, Inc.
> > Newsgroups: comp.databases.oracle
> >
> > 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
>
> --
> Jerry Gitomer ICT Group
> jgitomer_at_ictgroup.com Langhorne PA
> jgitomer_at_yahoo.com Opinions are mine not those of ICT Group
>

-----== 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:08:49 CDT