?
Solved

How to create "Schema" in Oracle 9iR2 win2k edition ?

Posted on 2003-03-06
3
Medium Priority
?
1,856 Views
Last Modified: 2012-05-04
Oracle 9iR2 win2k Edition installed, I created user and tablespace thru sqlplus. I seen the user, tablespace and datafile in GUI on Oracle Enterprise Manager Console, but do not see Schema, Please advisr how to create the schema from the sqlplus and how to create the schema from GUI of OEM console.

thanks,
0
Comment
Question by:joehuang
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 1

Expert Comment

by:jim144
ID: 8083113
A schema is basically a user that owns objects. If you grant the appropriate system permissions,  and then create objects (i.e. tables, indexes, synonyms, etc) owned by the user, you will now have a schema, and OEM will display it as such in the GUI.
0
 
LVL 1

Expert Comment

by:belem
ID: 8083248
CREATE USER schemaname IDENTIFIED BY password DEFAULT TABLESPACE yourtablespacename TEMPORARY TABLESPACE yourtemptablespace;
GRANT CONNECT TO schemaname;
GRANT PUBLIC TO schemaname;
GRANT CREATE PROCEDURE TO schemaname;

ALTER USER schemaname QUOTA UNLIMITED ON yourtablespacename;
0
 
LVL 8

Accepted Solution

by:
Danielzt earned 200 total points
ID: 8083496
Schema is logic collection concept.
You do not need to create a "schema" in Oracle RDBMS. You only need to create user account in databse.

When the user creates any database objects( tables, indexes, stored procedure,triggers,...), you will see a schema with the same name of the user.

If the user has no database objects, you can not see its schema from Oracle Enterprise Manager Console.


0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

765 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