Setup and configuration on Oracle

Creating an empty database on Oracle

Conenct to Oracle with SQL*Plus, SQL*Worksheet or Server Manager and execute:

CREATE TABLESPACE HIPERGATE7 DATAFILE 'C:\oraclexe\oradata\XE\hipergate7.dbf' SIZE 100M;
CREATE USER HIPERGATE IDENTIFIED BY HIPERGATE DEFAULT TABLESPACE HIPERGATE7 QUOTA UNLIMITED ON HIPERGATE7 QUOTA 0 ON SYSTEM;
GRANT CONNECT,CREATE SEQUENCE,CREATE SYNONYM,CREATE PUBLIC SYNONYM,DROP PUBLIC SYNONYM,CREATE PROCEDURE,CREATE VIEW,CREATE TABLE, CREATE TRIGGER TO HIPERGATE;