Re: Help with hosting multiple versions of the same schema (1 per client)

Sorry I hit send by mistake...

My big reasonning ofr not doing the FGAC are:

1. No personal experience with it before (weak, I cringe to add it, but I have some definate time issues)
2. My clients are small to mid-range companies that have different hosting needs (me host, they host, 3rd party host) so I really want a simple single solution that will work simply anywhere that has an oracle server
3. I believe you need the enterprise version of Oracle? I run on the small business solution (Standard One I think it was called)
4. Most clients (at least initially) are direct local competitors and I'm not sure I could sell the shared database concept...

I posted another solution in this thread. What is your take on that?

thanks for you time, even if you made my eyes water :-)

jack

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:41c622b9$1_2_at_127.0.0.1...
> Comments in-line. And not meant to be rude or disprespectful (Honestly).
>
> Jack Addington wrote:
>
>> Basically I have a small application that I am hosting the database for.
>> As each client comes online I need to create a schema for them.
>
> This is a terrible design ... truly horrible. Have you considered
> keeping all rows, for all clients, in a single table and adding a column
> for schema owner? If so why can't you use it?
>
> You mention FGAC later in your post. I would think that a single schema
> with FGAC would solve the entire problem. If not ... why? I don't see
> anything in your post that would preclude a normalized design.
>
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
> ==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
> =-----
Received on Mon Dec 20 2004 - 14:40:24 CST