What is an Oracle Schema?

Steve Callan at DBASupport has a long artical on What’s in an Oracle Schema?.

While I don’t get this exact question much, I do see that some people get confused between a database and a schema. I create them a schema in a database, give them the user name and password and they think they have a database.

If I ask them if they need a schema or a database they aren’t sure. So usually I just get their requirements and then determine it for myself. Part of being a DBA I guess.

I usually ask them how many uses they need, how much space they need and the number of users or amount of load they are expecting. If it is all pretty low, then they probably only need a schema in an existing database. If they have high demands then their own database might be best.

2 thoughts on “What is an Oracle Schema?

  1. Confusion between Oracle database and schemas are coming often from someone’s background in SQL Server as they have different terminology and security/object management model.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s