Friday, 3 June 2016

What is difference between user and schema in oracle database?

 
As you think, both user and schema in oracle database was same thing but there are few differences between them.
User is just a key to access the database resources, where as schema in oracle is collection of objects which contains the information about access to the resources.
Whenever you create user, schema is created by default with same name in oracle.