Create the Oracle InForm User Management Tool database instance

1. Set up an Oracle database instance.
2. Make sure the following instance DEFAULT tablespaces exist in the database instance:
   • SYSAUX
   • SYSTEM
   • UNDOTBS1
   • USERS
   • TEMP

   Oracle InForm-specific tablespaces:

   • TEMPBIG
   • INFORM
   • INFORM_LOB
3. Depending on your DB hardening, create specific tablespaces by running the following SQL commands:
   • SQL commands for hardening DB
     • INFORM

       
       CREATE TABLESPACE INFORM DATAFILE '/u01/oracle/oradata/trial1/inform01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED ENCRYPTION DEFAULT STORAGE (ENCRYPT) BLOCKSIZE 16K;

     • INFORM_LOB

       
       CREATE TABLESPACE INFORM_LOB DATAFILE '/u01/oracle/oradata/trial1/inform_lob01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED ENCRYPTION DEFAULT STORAGE (ENCRYPT) BLOCKSIZE 16K;

     OR

   • SQL commands for non-hardening DB
     • INFORM

       
       CREATE TABLESPACE INFORM DATAFILE '/u01/oracle/oradata/trial1/inform01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED BLOCKSIZE 16K;

     • INFORM_LOB

       
       CREATE TABLESPACE INFORM_LOB DATAFILE '/u01/oracle/oradata/trial1/inform_lob01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED BLOCKSIZE 16K;

   Note:

   Directory structure is provided as an example. Please make sure to match these commands to the directory structure of your Oracle installation.

   Note:

   For pluggable databases (PBDs), you can create custom names for the study database tablespaces. These custom names can follow any naming conventions that suit your study. For example "STUDY1" and "STUDY1_LOB".

   If only a single tablespace custom name is provided, then all large objects will be placed in that tablespace along with regular objects.

   If both tablespace custon names are provided, large objects will then be automatically palced in the specified LOB tablespace.

   If no custom names are needed, Oracle recommends using the default INFORM and INFORM_LOB names.

4. Create the TEMPBIG tablespace by running the SQL command:

   CREATE BIGFILE TEMPORARY TABLESPACE TEMPBIG TEMPFILE '/u01/oracle/oradata/trial1/tempbig.dbf' size 1000M reuse autoextend on next 500M;