Re: Renaming Fields in an Oracle Table

Rumours have it this will change with Oracle 8i

Regards,

Sybrand Bakker, Oracle DBA

Kai Horstmann wrote:

> kwelty_at_my-dejanews.com schrieb:
> >
> > Can someone give me some insight into the process that is required to > change
> > a field name in an Oracle Table?
>
> Hi
>
> there is no direct possibility to change the name of the column.
> You have to rename the table and create a new one with the old name
> with create table xxx (col1,col2,col3) as select col1,oldcol,col3 from
> renamed_table;
>
> Drop renamed_table.
> create indexes and constraints like the ones on your old table.
>
> Hope that helps
> Kai

Received on Thu Jan 28 1999 - 06:55:30 CST