Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: SUSOTT@amnutrition.com Newsgroups: comp.databases.oracle.tools Subject: Re: Designer6i, Allowable values code table Date: Fri, 12 Apr 2002 09:59:57 -0600 Organization: Posted via Supernews, http://www.supernews.com Message-ID: References: X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Complaints-To: newsabuse@supernews.com Lines: 39 Xref: easynews comp.databases.oracle.tools:50620 X-Received-Date: Fri, 12 Apr 2002 08:57:40 MST (news.easynews.com) "Surfnet" wrote in message news:a94taf$1ot$1@news.surfnet.nl... > Hello Susott, > this table is called cg_ref_codes or _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 > ref codes table is only to be used by one application. The name of the > generated table then changes to _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 > So under which circumstances would the cg_ref_codes table be better/more applicable/advantageous to use over a "codes table" manually created? (or would a manually created table have any advantages at all?)