Hi,
Unlike in other databases, a schema in oracle is equivalent to a user. So if you create a user , then Oracle automatically creates a schema for the user. When a user logs into oracle, all the tables, procedures, functions , views etc.. that he creates or modifies will be belonging to his schema(unless he has those privileges to other's schemas). A schema is not a place where the database objects are stored. It is rather a reference to a user with his specified privileges and grants on the database.
I had a tough time with this concept as I was working on DB2 earlier and was able to create multiple schemas for a user. When I started porting the application to Oracle, I came across this problem(well it was a problem to me) of Schema = user . I really wanted to have more than one schema for a user with different set of privileges for each of them. But I ended up creating multiple users instead.
Does anyone has any opinions or suggestions for this?
Any help is appreciated.