Some Thoughts on Oracle's Data Dictionary
... prompted by a slightly unrelated question, but leading in a nice direction I thought.
Edit: Oh, if anyone was confused then the link was reached by clicking on the post title. But here it is anyway http://dba.ipbhost.com/index.php?showtopic=1604
posted by David Aldridge @ 10:06 AM
2 Comments:
David,
Definitely agree. Maybe I am thinking in too simple terms, but isn't it easier to just ADD a column with the name you want, then copy the data from bad_column_name to good_column_name, then drop bad_column_name? That is usually what I do, easier than rebuilding table or hacking the data dictionary. Seems reasonably safe, if you can get the 5 minutes it takes to do it IMHO.
There are a great many arguments against and very few for, it seems.
Post a Comment
<< Home