MySQL Forums
Forum List  »  Oracle

"ORACLE Schema" in MySQL
Posted by: François Bivaud
Date: January 30, 2009 03:29AM

In ORACLE you can have multiple "schema" in the same database processus.

Cause you join there schema with sql query :
WHERE schema1.table1.field1 = schema2.table1.field1

you can add delete or modify one schema with no modification in others.
The schema is link to a user, right and tablespace.

In MySQL can we have multiple schema in the same instance and query for join there ?

thanks for yours answers!

Options: ReplyQuote

Written By
"ORACLE Schema" in MySQL
January 30, 2009 03:29AM
January 30, 2009 04:55PM
January 31, 2009 02:03AM
February 05, 2009 03:11AM

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.