Oracle in a Nutshell

Name

CREATE SCHEMA

Synopsis

CREATE SCHEMA AUTHORIZATION schema
[CREATE TABLE statement]
[CREATE VIEW statement]   
[GRANT statement]

Creates multiple tables and/or views and issues grants in a single statement.

Tip

You must have the same privileges required for the CREATE TABLE, CREATE VIEW, and GRANT statements to issue this statement. Individual statements within the CREATE SCHEMA statement must not be terminated with the SQL termination character.

Keywords

schema

Name of the schema to be created, which must be the same as your username.

CREATE TABLE statement

This is a CREATE TABLE statement, as shown later in the CREATE TABLE entry.

CREATE VIEW statement

This is a CREATE VIEW statement, as shown later in the CREATE VIEW entry.

GRANT statement

This is a GRANT statement, as shown later in the GRANT entry.