4.2 Create the Database Schema on Oracle Database

You need to create the following Database Schemas:

Tablespace

You can either use the existing Tablespace or can create a new Tablespace during schema creation using the following script:

Permanent Tablespace

CREATE TABLESPACE <tablespace_name >

DATAFILE '<tablespace_name >.dat'

SIZE 1G

ONLINE;

Temporary Tablespace

CREATE TEMPORARY TABLESPACE <tablespace_name >

TEMPFILE '<tablespace_name >.dbf'

SIZE 100M;