URGENT for COL$

Hi there,

If you are aware that in Oracle 7 we are able to rename column name using col$.

I did same stuff in 8.0.6 I got modified name in col$ and dba_tab_columns but whenever I describe defination I see old value.

It is urgent does somebody can help me?

Thanks
MUMS

Hi Moderator,

Can you tell me regarding this issue.

Regards
MUMS

havo to run catalog and catpoc after. Beeware on having indexes or constraints on the column you are modifying

Don't do it , but if u r using 8.1.6 ,why not add the new column and then drop the old one.

so my qustion will be why shouldn't I do it.

Does it have a bad effect on Database?

Thanks
MUMS

No not at all it will update all you datadictionary tables and plsql objects they wont make any change that can affect your database. because they simply recompile you all database objects.

Thanks to all for your efforts.

BEst Regards
MUMS

It is not a good practice to change col$ table. Sometimes, you may corrupt data dictionary, that will render the database useless.