What is Oracle Schema

Targeted Audience: Beginners

Till today I was of the illusion that USER and SCHEMA are both equal. But Oracle Guru Andrew Clarke describes the difference between both USER and SCHEMA in his blog. Thanks Clarke for your blog.

So understanding this difference we will define what an Oracle Schema is:

A Schema represents set of objects owned by the user of the same name. For example in an organization there are 100 employees, each of these employees should have a separate space where they manage their objects. It is synonymous with the concept of an employee been allocated a new cabin where he can keep or organize his belongings.

The same way in Oracle a user must be created for each database user. An organization can keep its own rules in naming the users but it is better to use a naming notation always in such cases. If a database user logs in to his space (using connect) he can create objects which becomes the schema.

What a schema can contain?
Just like a cabin where the employee sits; it can contain a PC, a deskphone, a cabinet for filing papers etc., a schema can contain various objects like tables, views, indexes etc. If you want to create any object it must be created inside any of available schemas.

How do I access my schema?
Accessing of a schema is guarded by a password which the DBA assigns at first. You can choose to change the password.

26 comments :

  1. Hi sir,
    The content is really helpful, now i have got a clear understanding of database schema.

    ReplyDelete
  2. Very good and simple explanation.
    Varsha

    ReplyDelete
  3. thanx for the post....it is really help full...

    ReplyDelete
  4. Very good analogy schema = cabin

    ReplyDelete
  5. Thanks all... for your comments...

    ReplyDelete
  6. Good Explanation...Thanks

    ReplyDelete
  7. Brilliant , fantastic...

    ReplyDelete
  8. Thank You really! Tat was helpful!

    ReplyDelete
  9. really clear and helpful

    ReplyDelete
  10. Brilliantly explained. This is the best content I have found that gave me a complete overview of this important concept in Oracle. Now I have completely understood the meaning of Oracle schema and what it represents. Thanks for sharing.

    ReplyDelete
  11. its really helpful to me to understand what exactly schema is.............


    Thanks,
    jyoti

    ReplyDelete
  12. thanks so much, this cabin thing will help me remember the definition of schema.

    ReplyDelete
  13. Simple way of explaining things and most of the things cleared. Thank you very Much.
    Regards
    Sanyog Tripathi

    ReplyDelete
  14. Thanks a lot for a very clear concept of Schema.

    Toshi

    ReplyDelete
  15. Really good explanation.. Tanks!

    ReplyDelete
  16. This comment has been removed by the author.

    ReplyDelete
  17. very well explained... Thanks for posting

    ReplyDelete
  18. it was extremely helpul..thank you

    ReplyDelete
  19. thanx its nice....example is so helpfull.

    ReplyDelete
  20. Good and helpful explanation. Thanks.

    ReplyDelete
  21. Good Explanation with relevant example. Thank you for sharing.

    ReplyDelete
  22. Nice Explanation...Can you give me some statement or code how to manage table and indexes etc.. using schema

    ReplyDelete
  23. Simply understood.Thank you for your explanations

    ReplyDelete