create schema on oracle

Hi,
I am confuse, I want to create a new schema = create a new user on the same database?

Thank you!
Francis SZE
LVL 15
fsze88Asked:
Who is Participating?
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
In oracle, both user and schema mean the same in the sense that when you create a user it means that you are setting up a schema in which database objects ( tables, view, etc ) reside and they are accessed by using the userid/password.

Technically speaking with respect to oracle, you can create an user with the above command. But if you want to setup the schema in one go by creating multiple objects,  you can optionally use a create schema command to do that.

http://ss64.com/ora/schema_c.html

But normally what is being done is, first an user is setup with the create user command and then required database objects are setup. So it is not mandatory that you need to use "create schema" command to setup your schema.

Thanks
0
 
sweetfa2Commented:
create user francis identified by francispassword;
0
 
fsze88Author Commented:
my question is create a new user is equal to create a new schema, is it?
Thank you!
Francis SZE
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
sweetfa2Connect With a Mentor Commented:
Yes, that is correct.  However your schema will be empty.
0
 
fsze88Author Commented:
But if you want to setup the schema in one go by creating multiple objects

multiple objects means multi users in one schema?
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
no.. a schema means it is for one user only.

multiple objects means multi users in one schema? ---> this means that if you want to setup n tables, x views, y sequences etc...

In this context, user is not a database object here.
0
 
fsze88Author Commented:
so, create schema is not a must, just create a user on one database
right?
Thank you
Francis SZE
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
Yes, that is what i said that it is not mandatory. But create user is mandatory if at all you need to setup a schema with objects.

Thanks,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.