create_schema.sh script

Use the create_schema.sh script to create the schema for your database.

CAUTION:

This script if executed on an existing database, will erase all the data.

Syntax

create_schema.sh [--tablespace=tablespace_name] [--silent]

Parameters

silent: Suppresses the confirmation messages.
tablespace: Specifies a table space name mapping file that shows the customized table space names for the required table spaces. If the table space parameter is not specified, all tables and indexes use the predefined table space names. For the first time, it will be the default names; after that, it will use the names that are used for previous create schema operations.

Usage

The script is stored in the <install dir>/bin/db directory. Running the script creates a log file that is named schema.log file in the <install dir>/logs directory.

Example

In this example, the create_schema.sh script is run with the parameter tablespace = test_table to create a new database schema.

$<install dir>/bin/db/create_schema.sh --tablespace=test_tablespace

Output

Running the create_schema.sh script displays the name of the database user, the client login command, and the JDBC details.