EDB is a PostgresSQL database that is wrapped in several Oracle features, this database is very similar to Oracle, even some queries and functions are the same. Here’s how to install EDB and allocate the tablespace :

Install EDB from Repository :

yum install epel-release 

yum install edb-as10 

Enable database :

systemctl enable edb-as-10 

systemctl start edb-as-10

If the command not running in your terminal, please go to folder here :

sudo su
su enterprisedb
cd /opt/edb/10/bin/ 

folder “/opt/edb/10/bin/” location the EDB database.

Create Folder tablespace for example (location folder /user/…):

sudo mkdir -p /user/data/tbsdata01 
/user/data/tbsdata02 /user/data/tbsdata03 
/user/data/tbsdata04 /user/data/tbsdata05 

sudo mkdir -p /user/index/idxdata01 
/user/index/idxdata02 /user/index/idxdata03 
/user/index/idxdata04 /user/index/idxdata05 

Change Qwnership of folder :

sudo chown enterprisedb:enterprisedb -R /user/data 

sudo chown enterprisedb:enterprisedb -R /user/index

Configure connection on.pg_hba.conf (location file is located on filesystem EDB/data),
for example /opt/edb/10/data, add host here:

host all all 127.0.0.1/32 trust

Create User database :

./createuser -D -i -l -P -s -h localhost -p 5432 -U enterprisedb diarycoding

Create tablespace :

create tablespace dataspace01 owner diarycoding location '/data/data/tbsdata01';
create tablespace dataspace02 owner diarycoding location '/data/data/tbsdata02';
create tablespace dataspace03  owner diarycoding location '/data/data/tbsdata03';
create tablespace dataspace04 owner diarycoding location '/data/data/tbsdata04';
create tablespace dataspace05 owner diarycoding location '/data/data/tbsdata05';
create tablespace indexspace01 owner diarycoding location '/data/index/idxdata01';
create tablespace indexspace02 owner diarycoding location '/data/index/idxdata02'; 
create tablespace indexspace03 owner diarycoding location '/data/index/idxdata03';
create tablespace indexspace04 owner diarycoding location '/data/index/idxdata04';
create tablespace indexspace05 owner diarycoding location '/data/index/idxdata05';

Create Schema database :

 create schema diarycoding_db; 

Create the database :

 create database diarycodingdb owner diarycoding tablespace dataspace01; 

Create extention for UUID :

 create extension if not exists "uuid-ossp"; 

Configure setting search path user, set variable here :

 search_path='"$user", diarycoding_db' 

Restart service edb database :

 systemctl restart edb-as-10 

www.diarycoding.com