Solved

create schema on oracle

Posted on 2010-11-29
8
392 Views
Last Modified: 2012-05-10
Hi,
I am confuse, I want to create a new schema = create a new user on the same database?

Thank you!
Francis SZE
0
Comment
Question by:fsze88
  • 3
  • 3
  • 2
8 Comments
 
LVL 17

Expert Comment

by:sweetfa2
ID: 34235870
create user francis identified by francispassword;
0
 
LVL 15

Author Comment

by:fsze88
ID: 34235959
my question is create a new user is equal to create a new schema, is it?
Thank you!
Francis SZE
0
 
LVL 17

Assisted Solution

by:sweetfa2
sweetfa2 earned 150 total points
ID: 34236081
Yes, that is correct.  However your schema will be empty.
0
 
LVL 28

Accepted Solution

by:
Naveen Kumar earned 350 total points
ID: 34236252
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 15

Author Comment

by:fsze88
ID: 34236357
But if you want to setup the schema in one go by creating multiple objects

multiple objects means multi users in one schema?
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 34236372
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
 
LVL 15

Author Comment

by:fsze88
ID: 34236432
so, create schema is not a must, just create a user on one database
right?
Thank you
Francis SZE
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 34236438
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now