Mark -- Thanks for the question regarding "Descriptive info for schemas?", version 9.2.0.7

Submitted on 19-Sep-2007 14:59 Central time zone

Tom's latest followup | Bookmark | Bottom

Last updated 24-Sep-2007 7:30

You Asked

Hi Tom. Thanks so much for this site! It has saved my staff and me many hours when looking for solutions to specific issues.

My question is whether there is a way to associate descriptive information with schemas in Oracle 9i or 10g. Specifically, we would like to label each user schema with their name and each application schema with the application name.

I've searched here, at tahiti.oracle.com, and on Metalink but can find nothing that seems to allow us to do this. Since this is possible with comments for tables and columns, I'm puzzled that Oracle doesn't provide a way to document schemas.

and we said...

there is only the comment command

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

and it does tables, columns, operators, index types and materialized views only.

To store this 'schema' metadata, you would create your own table to associate it to. It just is something that isn't implemented.

Reviews

Thanks September 20, 2007 - 12pm Central time zone

Bookmark | Bottom | Top

Reviewer: Mark Krudwig from Denver, CO USA

  Hi Tom.  Thanks for the follow-up.  I suspected that was going to be the answer, but was hoping 
that there was an Oracle-supplied alternative lurking in a corner somewhere.

  Is there any chance of seeing something along these lines as a future enhancement?

Followup September 24, 2007 - 7am Central time zone:

enhancements are made via support (the iTar process) - anything is possible... (not being tongue in cheek, rather - enhancements are supplied/input into the system that way and anything is possible over time)

Write a Review