Re: COMMENTS, USER_TAB_COMMENTS. Comments?
Date: 25 May 1994 10:46:25 -0600
Message-ID: <2rvvd1$hh0_at_tibalt.supernet.ab.ca>
Carl Gohringer (cgohring_at_lucifer) wrote:
> UNDER NO CIRCUMSTANCES should you EVERY attempt to manually update the
> Oracle data dictionary.
> These tables are meant to be updated by the kernel and the kernel only.
> This is not supported, and to boot, you are liable to mess things up quite
> severely, as the data dictionary is by no means in a format that even
> resembles normal form.
OK ... now that we've determined that the dictionary is 'abnormal' ...
the view 'USER_TAB_COMMENTS' is based on 'kernel' tables. They are updated by a special SQL*Plus COMMAND - COMMENT - that maintains all the required referential integrity. (I'm surprised that Oracle does not have constraints on these tables - oh well).
We have also run into this problem ... the ONLY acceptable solution if you are constrained to keeping the info in the database is to create extra user-space tables - similar in form to the USER_TAB_COMMENTS and USER_COL_COMMENTS views. To handle this and all sorts of other problems, such as keeping the structure of the table in the DB intact while making changes due to development or feature requests, I strongly suggest you use an appropriate CASE tool. ERWIN or Oracle's CASE come to mind.
/Hans Received on Wed May 25 1994 - 18:46:25 CEST