Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Schema Name and Database Name

 
JiaPei Jen
Ranch Hand
Posts: 1309
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I asked my supervisor the database name. He told me the schema name is "xxxx". Is schema name equivalent to the database name?
 
Julian Kennedy
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No. In a physical sense the word schema tends to mean a set of database objects (tables, etc.) owned by a specific user. A database may have several schemas.

Jules
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34835
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You didn't ask about this, but there are also nodes. A node may have several databases.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic