Embed Comments in DATABASE Itself 1

[jtanner]

Hello,

This could be tricky to explain so I'll present it this way:

Here is what I am NOT looking for:
* Putting comments in any kind of code (SQL, Java etc.).
* Putting Hints in SQL commands.
* Using the schema COMMENT property to add notes about it.

Here is what I am looking for:
* I want to embed some brief text comments (less then 2k) to the DATABASE itself.
* What is the method to create\change these DATABASE bound comments?

Thanks for your advice,

JT

 

[Turkbear]

Hi,
Must have been too tricky to explain..

What kind of comments? You can add comments to tables and fields that usually are used to explain some aspect of the MetaData regarding that object.

If you want a comment ABOUT the database ( actually the Instance, I assume), then create a table called <YOURSID>_COMMENT and use it.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jtanner]

Turkbear,

>> If you want a comment ABOUT the database ( actually the
Instance, I assume),

Cool suggestion. Thanks.

What I still dont know is: Is there a place in a database instance where I can embed some brief comments WITHOUT creating a custom table of my own to do so?

Thanks,

TJ

 

[engineer2100]

Why do you want this comment in the first place?

 

[Turkbear]

Hi,
To put something into a database you need to have something to put it in ( to use the technical terms )

In Oracle ( as in most databases) that is normally a Table,
or as part of an existing table's contents ( the Comment part)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jtanner]

>> In Oracle ( as in most databases) that is normally a Table,

Yes - I agree.

The core of what I am asking is, how can I do this with the most minimal introduction of custom changes?

Is there a (practical) place in the control file? Is there a table in SYSAUX that I can use etc.?

If I have to introduce a new object or mechanism to do this I accept that.

Thanks again for your comments,

JT

 

[Turkbear]

Hi,
Try reviewing this, should help you determine what to use:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4009.htm#i2119719

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jtanner]

engineer2100,

>> Why do you want this comment in the first place?

We want to include some brief comments on the role of the database in all our 10g databases in a standardized way.

We want to try to use the resources commonly available in all our 10g databases to do this, i.e. we want to try not to have to create a table in all our databases to achieve this (maybe one already exists from Oracle for this purpose?).

In our environment we have tools that can make use of this.


Thanks,

JT