Re: drop column?

Sybrand Bakker wrote:

> This is 8.1.5 command, drop is not supported in 8.*0*.5.
> He needs to use conventional methods
> - create a view without the column
> or
> create table ..._new as select ... from <old_table>
> drop <old table>
> rename <..._new> to <old_table>
>

But keep in mind you loose all grants
Stefan

>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "Fabio Franco" <fabio.franco_at_rsisistemi.it> wrote in message
> news:8mrdm1$3tc8$1_at_stargate1.inet.it...
> > The command is:
> >
> > alter table <table_name>
> > drop column <column-name>;
> >
> > Ed Zappulla <zappullae_at_rcn.com> wrote in message
> > 8mq715$dhl$1_at_bob.news.rcn.net...
> > > does anyone know how to drop a column in ora 8.0.0.5?
> > >
> > >
> > >
> >
> >
Received on Wed Aug 09 2000 - 00:00:00 CDT