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
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.