Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Renaming Columns

Renaming Columns

From: <mtillberg_at_my-dejanews.com>
Date: Wed, 26 Aug 1998 14:45:38 GMT
Message-ID: <6s172i$a8i$1@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 Wed Aug 26 1998 - 09:45:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US