at last i convinced my duhvelopers to go for individual tables.
> -----Original Message-----
> From: Steve Orr [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 22, 2001 5:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Single Code Table or Separate Code tables dilemma
>
>
> Regarding "lookup" or validation tables and more complex
> "rules" tables...
> do they ALL go into your master code table? For instance,
> what about a "code
> table" for all valid U.S. zip codes? Do they go into your
> master code table?
we r in the process for defining country--->state/province--->city and
airports tables. there would be another 30-40 masters and all in different
tables :-) sweet smell of victory
> State abbreviations too? What about valid city/state/zip code
> combinations
> which you can get from the U.S.P.O.? At what point are
> validation/lookup/rules data not in the master code table and
> how do you
> decide?
i blive every logical entity should hv its seperate physical presence.
but then every solution is an "Engineering Compromise". So i wont mind some
give and take. but its fun to have an occasional fight with a duhveloper.
> The code table technique may be fine for smaller apps
> but couldn't
> it become unwieldy for larger apps with 5000+ tables? Of
> which 1-3000 would
> be "lookup/validation tables?" Do Oracle ERP or SAP ERP apps do this?
> Curious.
check out PSAPOOLD tablespace in
http://www.oreilly.com/catalog/sapadm/chapter/ch01.html#18406
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Ghosalkar
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
