Re: Creation of Oracle databases

Meng wrote:

> Hi,
> We will migrate Mysql to Oracle soon. Now I have a question.
> We have
> 5 databases in one instance in Mysql. Do we need to create 5
> databases in Oracle, or only one? We have to start 5 instances
> and assign
> different sizes of RAM to them If we create 5 databases.
> Thanks in advance.
>
> Meng
>

        Look into using a single Oracle data base instance with five schemas, each owned by a different userid. You can then use the GRANT and REVOKE privilege SQL statements to control access to each of the five schemas.

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one