0 pts.
 Creation of a new schema in Oracle
My DBA insists that there isn't a role or privillige for create schema, from the research gathered so far there's clear indication that there should. What is the snytax for creating a new schema? The DBA isn't that he can only create a user not a schema

Software/Hardware used:
ASKED: September 1, 2005  5:16 AM
UPDATED: September 1, 2005  11:43 AM

Answer Wiki:
User/Schema are essentially the same thing. A schema is a user account that owns database objects such as tables, views, indexes, procedures, etc. Other user accounts would probably then be created that are granted privileges on the owning user/schema's objects in order to run an application. Each user account will have a specific default and temporary tablespaces associated along with system privileges and possible role/object grants. So, create the user, then create the user's objects or schema with create table, create view, create index, etc. DDL statements depending on how your schema is supposed to look.
Last Wiki Answer Submitted:  September 1, 2005  11:43 am  by  Kurthp   195 pts.
All Answer Wiki Contributors:  Kurthp   195 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _