Create Oracle Schema for Sterling Selling and Fulfillment Suite 8.0, 8.1, 8.5, 9.0, 9.1, and 9.2

Refer to create DB2 schema for Sterling Commerce for creating a DB2 schema for Sterling Selling and Fulfillment Suite.

Refer to Install Sterling 9.2 and 9.2.1 for Sterling 9.2 and 9.2.1 installation.

Here is the schema creation script that I have used since Sterling 8.0. It should help you to get started in creating your Sterling schema.

-- Create the table space so Sterling schema will be on its own schema

CREATE TABLESPACE "SMCFS_92_TS"

NOLOGGING

DATAFILE '/u02/oradata/SMCFS_92_TS.DBF' SIZE 200M AUTOEXTEND ON

ONLINE;

-- Create the user/schema for Sterling

CREATE USER "SMCFS_92_USER" IDENTIFIED BY "SMCFS_92_PASSWORD"

DEFAULT TABLESPACE "SMCFS_92_TS"

TEMPORARY TABLESPACE "TEMP"

PROFILE "DEFAULT";

GRANT "CONNECT" TO "SMCFS_92_USER";

GRANT "RESOURCE" TO "SMCFS_92_USER";

ALTER USER "SMCFS_92_USER" DEFAULT ROLE ALL;

GRANT CREATE TYPE TO "SMCFS_92_USER";

GRANT CREATE ANY PROCEDURE TO "SMCFS_92_USER";

GRANT CREATE PUBLIC SYNONYM TO "SMCFS_92_USER";

GRANT CREATE SYNONYM TO "SMCFS_92_USER";

GRANT CREATE ROLE TO "SMCFS_92_USER";

GRANT CREATE SEQUENCE TO "SMCFS_92_USER";

GRANT CREATE TRIGGER TO "SMCFS_92_USER";

GRANT CREATE VIEW TO "SMCFS_92_USER";

GRANT CREATE MATERIALIZED VIEW TO "SMCFS_92_USER";