Re: How to rename a column name?

You can export the table. Create a table of the required structure that you like and import the data into the new table.

                                        Tapan

wy3141_at_my-deja.com wrote:
>
> I want to change the column name,and I don't want to drop it and
> recreate it. Because it has some dependencies(role right,constraints)
> on it.
> Can Oracle support change the column name directly?
> Any suggestion are helpful.
> Thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Received on Mon Sep 13 1999 - 17:18:24 CDT