Re: Field Definitions

From: GreyBeard <Fuzzy.GreyBeard_at_gmail.com>
Date: Tue, 22 Mar 2005 00:39:15 GMT
Message-Id: <pan.2005.03.22.01.40.38.68331@gmail.com>

On Mon, 21 Mar 2005 15:32:19 -0800, mike wrote:

> Well, thanks for all the comments .... and the nitpicking as well.
>
> BTW, user_col_comments and user_tab_comments is probably more
> appropriate for me to update than all_col_comments that Sy was talking
> about above, correct?
>

Those are all VIEWS and they reference dictionary tables. All are owned by SYS and none are directly updateable unless you are hankerin to bust the database.

The only legitimate way of updating them is using the COMMENT ON command, just the same as the only legit way of creating a table is the CREATE TABLE command instead of updating all the dictionary tabless by hand.

(Time in the books, especia;lly the CONCEPTS manual at http://docs.oracle.com is highly useful.) Received on Mon Mar 21 2005 - 18:39:15 CST