Designer6i, Allowable values code table
From: <SUSOTT_at_amnutrition.com>
Date: Wed, 10 Apr 2002 17:21:52 -0600
Message-ID: <ub9i8gt5ii7b26_at_corp.supernews.com>
[Quoted] [Quoted] We are running Oracle 8i/Designer6i on windows2000 server. In building [Quoted] 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? Received on Thu Apr 11 2002 - 01:21:52 CEST
Date: Wed, 10 Apr 2002 17:21:52 -0600
Message-ID: <ub9i8gt5ii7b26_at_corp.supernews.com>
[Quoted] [Quoted] We are running Oracle 8i/Designer6i on windows2000 server. In building [Quoted] 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? Received on Thu Apr 11 2002 - 01:21:52 CEST