Solved

create schema on oracle

Posted on 2010-11-29
8
394 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
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 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
 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Syntax 8 65
oracle 11g 23 73
Use of Exception to end a Loop 3 31
run sql script from putty 4 32
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

813 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

13 Experts available now in Live!

Get 1:1 Help Now