rename column name in sys.col$

[dinocwh]

i am going to rename my column name in sys.col$
any concerns?

update sys.col$
set name = 'NEWNAME'
where name = 'OLDNAME';

commit;

alter system flush shared_pool;

[Mr.Hanky]

Mind if I ask why?

MH

[gpsingh]

Any Dependent code using the old column name , like SP,truggers etc.
Old backups would be useless for the table.
and i think if i rememeber correctly , re running of catblock and catproc after this screws up the data dictionary.

[Mr.Hanky]

I would do an emport of that table before altering it, just as a precaution.

MH

[Shestakov]

Do u sure that not exists any dependenses to this column?
---------------------------------------
More safety (if Oracle 8i):

1. add column to this table with new name.
2. update table (set new_col = old_col)
3. drop old column from table.
4. reset all constraints
5. recompile all packages, triggers ...

[dinocwh]

coz of adding a new column with incorrect name...
i think after renaming it, do an export and import will be more safe... agree?

[SANJAY_G]

I would recommend not to mess-up with dictionary tables/views. Or be prepared for consequences. It is not at all recommended to modify data dictionary.

Sanjay