Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g Express, should just about kill the MySQL and Postgresql gang

Re: Oracle 10g Express, should just about kill the MySQL and Postgresql gang

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Mon, 07 Nov 2005 12:11:01 -0600
Message-ID: <lu5vm1p8t6jt46babol1h38r13ldtb8tr1@4ax.com>


"boobie" <boobie.webdeveloper_at_mailnull.com> wrote:

>
>"HansF"
>> Why can you not separate by schema? Why do you want to incur the overhead
>> of separate instances?
>
>Of course, 100% agree. and 100% obvious.
>But.....
>Please step OUTSIDE of the typical Oracle-centric ways of thinking for a
>sec,
>please step outside the Enterprise Oracle-DBA role for a sec....
>and think in the context of the "open-source MySQL/PHP" to understand what I
>was trying to say.
>How about an example:
>----------------------------------------------------------------------------
>------------------------
>e.g.
>Joey is a freshman. He took some beginner Oracle classes.
>His church has a web site (hosted by ACME hosting company) consisting a few
>static pages.
>
>Church wants to add more content, forms and dynamic pages for this and
>that.....church needs help
>Joey says to self "aha ! with XE I can help my chucrch and also learn
>things ! great !"
>
>Too bad, there will be 2 possible outcome:
>1) ACME found out about the "single instance" limitation and informs Joey
>"Sorry we already installed one on this server
>for another customer....but we can put up a MySQL for you...."
>2) ACME never bothers to check and unknowingly they are all running afoul of
>the license agreement.
>----------------------------------------------------------------------------
>---------------------------
>
>So , IMO, with that "single-instance-per-server" limitation....XE can barely
>touch MySQL share,
>
>

Actually you have made the ACME Hosting service less than helpful to Joey..

If they were any good at customer service that would let Joey know that a separate schema ( Not Instance) can be created within the existing single Oracle instance for his needs...He can be granted sufficient rights to manage his own schema and his church users would be allowed access to only that schema...

No license violation ( as I read it) and no need for MySql... Received on Mon Nov 07 2005 - 12:11:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US