Re: rename col

This simple task requires a lot of work to do. The entire table must be copied and
all constraints, triggers, etc. have to be rebuild. Have a look at www.keeptool.com.
The tool "Hora" can do it for you. Simply right-click any column and select "rename"
from the popup menu. You can perform it at hoc or generate a script file.

Best regards
Holger

--
Holger Heidenbluth
NIS Rheinsberg GmbH, Am Langen Luch 3, D-16831 Rheinsberg
Phone. +49-33931-415-27, mailto: holger.heidenbluth_at_nis-rheinsberg.de


rcn <zappullae_at_rcn.com> schrieb in im Newsbeitrag:
9aa14f$t51$1_at_bob.news.rcn.net...


> is there a way to rename a col without having to add the new col, copy

 data


> to it and drop the old col?  Oracle 8.1.6.

>

> how about renaming a table?

>

>

>