• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3194
  • Last Modified:

create Database schema in oracle 10g

Hi ,

How to create Database schema in oracle 10g.

Sathish David  Kumar N
Sathish David  Kumar N
  • 2
2 Solutions
Raja Jegan RSQL Server DBA & ArchitectCommented:
Sathish David Kumar NArchitectAuthor Commented:
is it any differents between schema and new database ?
new schemas are created in a database...
so, schema and database are different.
all schemas have their own objects. vs...

to create a new schema,

CREATE USER <your_schema_name> IDENTIFIED BY "<your_password>"
 DEFAULT TABLESPACE "<your_tablespace>"
 TEMPORARY TABLESPACE "<your_temp_tablespace>";

after creating a schema,
you should grant your schema to create a session, to create an objects, vs...

Raja Jegan RSQL Server DBA & ArchitectCommented:
Some information about Schemas here:


Schema is an object that can be created in a Database. Hence a database can have more than one schema in it.
Hope this clarifies.
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now