Can I create multiple schemas in Oracle for one user?

Want to create multiple schemas for one user in Oracle? Learn whether it's possible here.

How do you create multiple schemas for the same user account in Oracle? Is it possible or not in Oracle?
It is not possible. In Oracle, a user = a schema. When you create an Oracle user, it is tied to the schema with the same username. You cannot create any additional schemas for that user. Instead, just create another user! If the first user needs to "see" the new user's schema, you can grant permissions to do so.

Dig Deeper on Oracle database administration

Data Management
Business Analytics
SearchSAP
TheServerSide.com
Data Center
Content Management
HRSoftware
Close