Create the Database Schema on Oracle Database

Create the following Database Schemas:

Tablespace

You can either use the existing tablespace or you can create a new tablespace during the schema creation by 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;