Prepare an Oracle database

We need to prepare a Db2 Database for use with WebSphere Commerce by creating a table space and user.

Task info

Procedure

1. (Oracle) Create an Oracle database table space with the following steps:

   1. Create a table space.

      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;

   2. Create a temporary table space.

      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;

2. (Oracle) Create a database user with the following steps:

   1. <Need description on the purpose of this command>

      alter session set "_ORACLE_SCRIPT"=true; 

   2. Create a database user.

      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;

   3. Grant authorities to the user with the following command:

      GRANT CREATE PROCEDURE, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE VIEW, CREATE MATERIALIZED VIEW TO <user_name>;

Previous topic: Install and configure Oracle 12c Release 2 database
Next topic: Loading the WebSphere Commerce database schema