Andreas Moroder wrote:
> Hello,
>
> i have a big table with 25 fields that should be checked for their
> contents. Because I also need the description of this values I should
> build 25 table and activate referential integrity.
>
> When I go on this way I will end with hundreds of very small tables.
>
> Is there another way to guarantee referential integrity ?
>
> I tried with functional indices on one single lookup table, but they can
> not be used a foreign key.
>
> Bye
> Andreas
How many different values in some of those columns? Could you implement
check constraints? If not leave it alone.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jun 02 2006 - 17:12:05 CDT
