-
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.
Best Regards,
Harsh Shah
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|