Is it possible to rename a column in a Oracle table in 8i or 9i.
create a new column . update it from first and drop it.
8i OCP DBA
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be
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
You can if you think you can.
Click Here to Expand Forum to Full Width