Re: Designer6i, Allowable values code table

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?

Hi,
I think you would be better of to use a separate 'all_domain' table and domain-key-constraints to achieve what you want. Then youd DBA would be able to manipulate the domain values in every way, no regeneration whatsoever needed.
You can find more info on domain-key-constraints on Metalink  hth
Frans H. Received on Thu Apr 11 2002 - 11:39:47 CEST