5.1.4.2 Configure and Create a Database Schema

Creation of a Database Schema requires sysdba access.

Log in as sys user and create an Oracle schema. This schema will be used by the Starter Kit during installation to deploy the Starter Kit objects.

Sample syntax to create a database schema:

create user <username> identified by <password>

Note:

• <username> refers to the actual schema user name.
• <password> refers to the actual schema password.

Example:

create user skituser identified by password123

Assign Tablespace and Quota to the Schema created.

DEFAULT TABLESPACE	Default Users tables or Assign any permissible existing valid tablespace.
TEMPTABLESPACE	Default TEMP or Any Permissible existing valid temporary tablespace name.
QUOTA	Enter the quota to be set on the DEFAULTTABLESPACE attribute for the schema/ user. By default, the quota size is set to 500M. Minimum: 500M or Unlimited on default Tablespace.

Sample syntax to assign tablespace and quota to a database schema:

alter user <<username>> DEFAULT TABLESPACE <<USERS>> quota unlimited on <<USERS>>;

Note:

• <username> refers to the actual schema user name.
• <USERS> refers to the actual default tablespace.

Example:

alter user skituser DEFAULT TABLESPACE USERS quota unlimited on USERS;