Creating the Oracle Schema for Emptoris Sourcing

You must create the Oracle schema for configuring the Oracle database.

To create Oracle schema, complete the following tasks:

1. Create the Oracle user.
2. Assign SPDATA as the default table space and TEMP as the temporary table space to the user.
3. Assign unlimited quota to the user on SPDATA.
4. Grant the following privileges to the user.

   CONNECT
   RESOURCE
   CREATE SESSION
   CREATE TABLE
   CREATE VIEW
   CREATE PROCEDURE
   CREATE SEQUENCE
   CREATE TRIGGER
   CREATE SYNONYM
   GRANT EXECUTE on SYS.DBMS_LOB
   GRANT EXECUTE on DBMS_AQADM
   GRANT EXECUTE on DBMS_AQ
   GRANT SELECT on pending_trans$
   GRANT SELECT on dba_2pc_pending
   GRANT SELECT on dba_pending_transactions
   GRANT EXECUTE on dbms_system (For Oracle 10.2.0.3 or lower
   JDBC driver)
   GRANT EXECUTE on dbms_xa to (For Oracle 10.2.0.4 or higher
   JDBC driver)

5. Import the provided data dump for the installation using the following command: DOS/UNIX> imp <myuser>/<mypwd> file=esp_seed.dmp \ fromuser=(esp_rigel) touser=(<myuser>)grants=N log=impSP.log
   Note: The sample data dump file is created with the Oracle 11g export utility and must be imported using the Oracle 11g import. It cannot be imported with the 10g import utility.
   Note: The esp_seed.dmp file is of 16 MB. Extract the Emptoris® Sourcing product file to procure this file.