MySQL Forums
Forum List  »  Oracle

problem matching oracle database to mysql
Posted by: sloth fur
Date: January 06, 2010 02:36PM

HI,
I'm using Mysql 5.1 on Windows.

I'm having some problems creating databases in Mysql to match what I have in Oracle.

For example:
In Oracle, I have a DB1 database. Inside DB1 I have schema1, schema2.

In MySQL, when I do the following:
create database DB1;
use DB1;
create schema schema1;
create schema schema2;

show databases;
The result is shown as DB1, schema1, schema2 databases.

My question is: Is there a way to create databases in Mysql as you would in Oracle ? THe reason I asked is b/c I have 3 Oracle databases that have the same schemas. How can this be done in Mysql b/c it would overlap.

I'd appreciate any suggestions.

Options: ReplyQuote


Subject
Views
Written By
Posted
problem matching oracle database to mysql
3230
January 06, 2010 02:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.