add in recreate indexes and grants and you should be there.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"AF" <af_at_nospam.com> wrote in message news:ahk97q$s48$1_at_pith.uoregon.edu...
> This should work.
> Lets say you have a table t1 with columns a, b and the offending c
>
> Create table t2 as ( Select a, b from t1)
> drop table t1
> create table t1 as (select * from t2)
> drop table t2
>
> All done. But be careful no warranty expressed or implied :)
> A
>
>
> "dani" <drezusta_at_airtel.net> wrote in message
> news:ahj2k7$9ad$1_at_nsnmrro2-gest.nuria.telefonica-data.net...
> > Hi,
> > I got a problem, I don't know what it's the correct syntax to eliminate
a
> > column in a table.
> > I've tried with : "ALTER TABLE t DROP COLUMN c", but doesn't work
> >
> > Any idea ?
> >
> > thanks
> >
> >
> > Dani
> >
> >
>
>
Received on Tue Jul 23 2002 - 14:03:38 CDT
