Always do a
alter system flush shared_pool
after commiting the updates!!!
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 Thu Aug 27 1998 - 17:24:05 CDT
