Re: Renaming a column in 8i Personal version

Thanks a lot.

Julius

"TurkBear" <noone_at_nowhere.com> wrote in message news:gp9vhtcpuqjits5f4f3qp33m04m2okqpr8_at_4ax.com...
>
> You fail to specify what version of Oracle you are using, but, generally,
 you
> cannot rename a column...
> Since the table is empty try this:
> when connected as OwnerC:
> rename TableB to TableB_Old;
> create TableB as select ColumnA NewColumnName,* from TableB_Old;
>
>
Received on Thu Jun 07 2001 - 11:37:18 CDT