Re: Schema Design.
Date: Fri, 10 Dec 2010 20:32:45 +1100
Message-ID: <idss3m$mca$1_at_news.eternal-september.org>
Preston wrote,on my timestamp of 9/12/2010 9:28 PM:
>
> A separate schema for each app is one option, but who gets the
> tables/procs used by multiple apps? We could use a "SHARED" schema for
> those, but I suspect that would get messy as people develop
> app-specific objects in the future then realise they could be used by
> other apps too& move them to "SHARED". Either option could be a
> nightmare when it comes to remembering to put schema. in front of the
> object names, not to mention the potential re-work needed if objects
> are moved to different schemas.
>
> Thoughts anyone?
>
Aw, never mind all that "complexity".
Just use this:
http://blogs.oracle.com/mdm/2010/12/oracles_global_single_schema.html
(yegawds, is there no limit to the idiocy of these people?...) Received on Fri Dec 10 2010 - 03:32:45 CST