Re: 23,000 Tables?

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 19 Nov 2006 10:45:51 -0800
Message-ID: <1163961962.916901@bubbleator.drizzle.com>

cd2448 wrote:
> HansF wrote:

>> On Wed, 15 Nov 2006 17:33:42 -0800, cd2448 wrote:
>>
>>> i would love to. but we don't have  the option to normalize the tables,
>>> which would be the real best practice approach, because we must have
>>> all fields in one table for a given report. i agree that there are
>> What is wrong with having normalized tables and placing views on top of
>> the tables to satisfy the reports constraints?
>>
>> --
>> Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)
>> *** Feel free to correct me when I'm wrong!
>> *** Top posting [replies] guarantees I won't respond.

>
> Thanks Hans,
>
> This seems like something that we could do - but would we be able to
> INSERT via the views? As you can see, I am not a database design expert
> by any means, even the basics are new to me, so I appreciate any
> feedback I am getting from talking to you guys.
>
> Rgds, cd

Yes.

If you need help finding an Oracle consultant to help you contact me off-line and I'll see if I know someone in your area.

-- 
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 Sun Nov 19 2006 - 12:45:51 CST