SearchOracle.com

Can I create multiple schemas in Oracle for one user?

By null

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.

20 May 2009

All Rights Reserved, Copyright 2003 - 2024, TechTarget | Read our Privacy Statement