.comment-link {margin-left:.6em;}

Oracle Sponge -- Now Moved To Wordpress

Please use http://oraclesponge.wordpress.com

Friday, April 29, 2005

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

2 Comments:

At 11:17 AM, Blogger Bill S. said...

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.

 
At 12:10 PM, Blogger David Aldridge said...

There are a great many arguments against and very few for, it seems.

 

Post a Comment

Links to this post:

Create a Link

<< Home