Re: Designer6i, Allowable values code table

Hello Susott,
[Quoted] this table is called cg_ref_codes or <applicationname>_ref_codes. A set of allowable values is called a domain. A column can be based on a domain. If you generate a table which has a column based on a domain a script is generated. In this script you will find a couple of lines that - deletes all allowable values for the domain involved - inserts the new allowable values for the domain/column/table If you edit the generated script and only run this part, you'll be fine. The application does not even have to be restarted. And the DBA can indeed go in the table and remove unused values, in necessary.

There is one property you can consider.
Designer has some setting for a 'application specific ref codes table'. It shows up somewhere in the Generator Options dialog. This would mean that the [Quoted] ref codes table is only to be used by one application. The name of the generated table then changes to <app>_ref_codes where app is the three letter short name of your application. You can also have a ref codes table that is used by more applications; it is then usually called cg_ref_codes. This is explained in the online-help.

Hope this helps.
Regards, Joost

--
Joost Bataille
University of Amsterdam ICT centre
www.ic.uva.nl

<SUSOTT_at_amnutrition.com> wrote in message
news:ub9i8gt5ii7b26_at_corp.supernews.com...


> We are running Oracle 8i/Designer6i on windows2000 server.  In building


> tables, we have several columns where we need to limit the values allowed,

> but also allow for the addition/deletion of the allowed values.  It was

> pointed out that Oracle has a dynamic allowable values table which should

> satisfy our requirements.  I understand that we can change the allowable

> values in the respository and generate the table into the instance.  That

> the only requirement to use the new values is for the application to be

> restarted.  The "help" text states that there is no procedure to remove

> unused values.  Would the DBA be able to go into the table directly and

> remove unused values?  Would you provide any other thoughts on this as we

> are new to Oracle and its way of thinking?

>

>