Re: Renaming Columns

From: GMAN <gman_at_siscom.net_NOSPAM>
Date: Sat, 29 Aug 1998 00:28:21 -0400
Message-ID: <MxKF1.29$g4.391196@news.siscom.net>

For what it's worth, ORACLE SAYS NEVER MODIFY THE DATA DICTIONARY!

You are asking for trouble if you do....

mtillberg_at_my-dejanews.com wrote in message <6s172i$a8i$1_at_nnrp1.dejanews.com>...
> I know it's been posted that columns cannot be renamed, but I was
wondering
>if anyone has tried this by directly modifing the sys.col$ table. I'd do
it
>myself, but I'm more of a programmer than a DBA and we don't have a very
good
>backup system going yet. I've done something similiar to this, modifying
the
>on delete cascade flag for constraints. I update the refact column in the
>sys.cdef$ table. It works, although it seems to take a while for the
changes
>to take effect. I was wondering if this would also work for the column
>names.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Aug 28 1998 - 23:28:21 CDT