1. Install and create Database

    Version               : 11.2.0.3.0 or later
    Database Characterset : AL32UTF8

    *Please create Tablespace depending on your environment and situation.

       Tablespace for tables
       Tablespace for indexes
       Tablespace for binary data

2. Create users

   Execute below command by sys or system user using sqlplus.

   (1) Create user for application

        create user mtpusr identified by mtpusr default tablespace USERS temporary tablespace TEMP;

   (2) Give the authority to the application user

        grant CONNECT,RESOURCE to mtpusr;

   (3) Create admin user

        create user mtpadm identified by mtpadm default tablespace USERS temporary tablespace TEMP;

   (4) Give the authority to the admin user

        grant CONNECT,RESOURCE to mtpadm;

    *Please grant DBA role according to your need.

3. Create tables, sequences and triggers

   We have two kinds of DDL according to Oralce Editions.

      Enterprise Edition (11g) : oracle_partition folder (If partition option available)
      Enterprise Edition (12c) : oracle_partition folder (If partition option available)
      Standard Edition (One)   : oracle folder (Partition option not available)

   Execute CREATE_TABLE.ddl in the folder for your Oracle's Edition.

    *If you make the Tablespaces for indexes or binary data,
     please modify the DDL to use that tablespaces.
    *Create "OBJ_STORE_TMP" table on application user's schema, specially.

4. Give the authority to application user and create synonym

   Execute the commands made by below select commands by admin user.

    <Grant to application user>
    SELECT 'grant SELECT,INSERT,UPDATE,DELETE ON mtpadm.' || TABLE_NAME  || ' to mtpusr;' FROM USER_TABLES;
    SELECT 'grant SELECT ON mtpadm.' || SEQUENCE_NAME  || ' to mtpusr;' FROM USER_SEQUENCES;

   Execute the commands made by below select commands by admin user.

    <Create synonym>
    SELECT 'create synonym mtpusr.' || TABLE_NAME  || ' for mtpadm.'  || TABLE_NAME  || ';' FROM USER_TABLES;
    SELECT 'create synonym mtpusr.' || SEQUENCE_NAME  || ' for mtpadm.' || SEQUENCE_NAME  || ';' FROM USER_SEQUENCES;

