undefine newname
undefine oldname
undefine ownername
undefine tablename
update SYS.COL$ c
set c.NAME = '&&newname'
where c.NAME = '&&oldname'
and c.OBJ# in (select o.OBJ# from SYS.OBJ$ o, SYS.USER$ u
where o.OWNER# = u.USER# and u.NAME = '&&ownername' and
o.NAME = '&&tablename');


btw its not supported by oracle :-)


You will have to bounce the database after doing this for you to see the change


Hope this Helps