CREATE SCHEMA

Create multiple tables, views and grants in a single transaction.

Summary of Syntax:

   CREATE SCHEMA AUTHORISATION schema options

   options
      CREATE TABLE
      CREATE VIEW
      GRANT

The schema name must be an existing Oracle username.

"In the small matters trust the mind, in the large ones the heart" - Sigmund Freud

Related Commands:

CREATE USER

Related Views:

  DBA_ALL_TABLES       ALL_ALL_TABLES       USER_ALL_TABLES
  DBA_TABLES           ALL_TABLES           USER_TABLES         TAB
  DBA_USERS            ALL_USERS            USER_USERS 
  DBA_VIEWS            ALL_VIEWS            USER_VIEWS



Back to the Top

Simon Sheppard
SS64.com