Creating Tablespaces

Table spaces are required to hold data and indexes for all tables required for ibi MDM and for all data sources uploaded.

Procedure
1. Change the default data file location specified in the createtablepsace.sql file based on your Oracle installation.
   1. Go to $MQ_HOME/db/oracle/configure/.
   2. Open the createtablepsace.sql file.
   3. Change the data file location for all tablespaces. For example, if you have installed Oracle in the E:/app/oradata/orcl folder, change the C:/oracle/version/oradata/orcl path to E:/app/oradata/orcl.
2. Run the createtablepsace.sql script to create the following tablespaces:

   Tablespaces

   Tablespace Name	Description
   VELODBDATA	For fixed ibi MDM tables.
   VELODBINDX1	For fixed ibi MDM table indexes.
   VELODBDF	For ibi MDM data source tables
   VELODBDATA	For ibi MDM master catalog tables.
   VELODBINDX	For ibi MDM master catalog table indexes.

   Note:

   • The VELODBDATA1 tablespace has a minimum size of 100 MB and maximum size of 500 MB. The remaining tablespaces are 100 MB. You can change the size of the tablespaces based on you requirement. You can also set the size as unlimited for the tablespaces.
   • If you are migrating from the earlier versions of Oracle to the latest supported version of Oracle, you have to explicitly grant UNLIMITEDTABLESPACE to the user. Oracle has discontinued the support granting UNLIMITED TABLESPACE to the RESOURCE role user.

     Run the following command:GRANT UNLIMITED TABLESPACE TO username

3. For a complete installation (tablespaces and seed data), run the installation script from $MQ_HOME/db/oracle/configure/doall.bat or doall.sh
   1. To create tablespaces without seed data, run $MQ_HOME/db/oracle/configure/createusertablespace.sh or .bat
   2. To create only seed data, see Creating Seed Data Manually for Oracle Database.

Top