Preparing an Oracle database

You need to prepare Oracle Database for use with HCL Commerce+ by creating a table space and user.

About this task

Procedure

Create an Oracle database table space using the following steps:

Create a table space by running the following command:

CREATE TABLESPACE <tablespace_name> DATAFILE '<tablespace_name>.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED;

For example, to create table space wcs_t:

CREATE TABLESPACE wcs_t DATAFILE 'wcs_t.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED;

Create a temporary table space by running the following command:

CREATE TEMPORARY TABLESPACE <temp_tablespace_name> TEMPFILE '<temp_tablespace_name>.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED;

For example, to create temporary table space wcs_temp_t:

CREATE TEMPORARY TABLESPACE wcs_temp_t TEMPFILE 'wcs_temp_t.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED;

Create a database user using the following steps:

Create a database user by running the following command:

CREATE USER <user_name> IDENTIFIED BY <database_name> DEFAULT TABLESPACE <tablespace_name> TEMPORARY TABLESPACE <temp_tablespace_name> QUOTA UNLIMITED ON <tablespace_name>;

For example, to create user wcs:

CREATE USER wcs IDENTIFIED BY wcs1 DEFAULT TABLESPACE wcs_t TEMPORARY TABLESPACE wcs_temp_t QUOTA UNLIMITED ON wcs_t;

Grant authorities to the user by running the following command:

GRANT CREATE MATERIALIZED VIEW, ALTER ANY TABLE, CREATE TABLE, UNLIMITED TABLESPACE, CREATE VIEW, DROP ANY SYNONYM, CREATE SYNONYM, DROP ANY INDEX, ALTER ANY INDEX, DELETE ANY TABLE, UPDATE ANY TABLE, INSERT ANY TABLE, DROP ANY TABLE, CREATE ANY TABLE, CREATE ANY SYNONYM, LOCK ANY TABLE, CREATE TRIGGER, CREATE ANY INDEX, SELECT ANY TABLE, CREATE SESSION, CREATE PROCEDURE, CREATE SEQUENCE, CREATE ANY VIEW, DROP ANY VIEW to wcs;