Re: Dropping Columns??

True the only way to get rid a of column is to recreate the table, but go to my web site and get my drop column package, it will do all the dirty work for you.

joe

Karsten Weikop wrote:

> No.
>
> The only way is to recreate table.
>
> Karsten
>
> Mark Cudmore wrote:
>
> > Is it possible to drop columns in a table in Oracle? I've never had to do
> > this, but I have normalized a table, and I need to drop some of the columns
> > in the original table, and I don't want to re-create the table because I
> > have a number of triggers and other tables dependent on that table! Help!
> >
> > --
> > Mark Cudmore
> > email: mcudmore_at_kamloops.env.gov.bc.ca

--
Joseph S. Testa, Oracle Database Administrator
Vice-President Ohio Oracle Users Group, http://www.ooug.org
Looking for an Oracle DBA on contract basis for remote DBA work? send
mailto:teci_at_oracle-dba.com
Need to drop a column from a table go to http://www.oracle-dba.com
ICQ http://wwp.mirabilis.com/2832230