Ask the Expert

Can I create multiple schemas in Oracle for one user?

How do you create multiple schemas for the same user account in Oracle? Is it possible or not in Oracle?

    Requires Free Membership to View

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.

This was first published in May 2009

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.