oracle schema vs sql schema
Hi there,
I wanted to find out if i can create multiple schemas in mysql as i can in Oracle.
for example: in Oracle i can create a database called "MYDB" and within mydb database i can create many schemas like "myclientschema1" and "myclientschema2". Then i can access a table called "table1" in any of the schema as MYDB.myclientschema1.table1. The reason for this is because the schema for every client is slightly different from one another.
Or DO i just create a separate "database" in mysql for every client and i would access table as myclientschema1.table1
Any help will be appreciated.
thank you
Subject
Views
Written By
Posted
oracle schema vs sql schema
5963
May 17, 2008 10:52AM
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.