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 some kinds of DDL according to use.

      Use RDB native partition : oracle_partition
      Use Pseudo-Partition : oracle_pseudo or oracle_pseudo_128
      Not use partition : oracle

   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;

