Table spaces are required to hold data and indexes for all tables required for TIBCO MDM and for all data sources uploaded.
TIBCO MDM uses the following different kinds of tables and indexes:
Fixed tables
Indexes for fixed tables
Data source tables
Master catalog tables
Indexes for master catalog tables
Procedure
Change the default data file location specified in the createtablepsace.sql file based on your Oracle installation.
Go to
$MQ_HOME/db/oracle/configure/.
Open the createtablepsace.sql file.
Change the data file location for all table spaces. For example, if you have installed Oracle in the E:/app/oradata/orcl folder, change the
C:/oracle/ver/oradata/orcl path to E:/app/oradata/orcl.
Run the createtablepsace.sql script to create the following table spaces:
Tablespaces
Tablespace Name
Description
VELODBDATA
For fixed TIBCO MDM tables.
VELODBINDX1
For fixed TIBCO MDM table indexes.
VELODBDF
For TIBCO MDM data source tables
VELODBDATA
For TIBCO MDM master catalog tables.
VELODBINDX
For TIBCO MDM master catalog table indexes.
Note:
The VELODBDATA1 table space has a minimum size of 100 MB and maximum size of 500 MB. The remaining table spaces are 100 MB. You can change the size of the table spaces based on you requirement. You can also set the size as unlimited for the table spaces.
If you are migrating from the earlier versions of Oracle to Oracle 12c version, you have to explicitly grant UNLIMITED TABLESPACE 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
For complete installation (table spaces and seed data), run the installation script from
$MQ_HOME/db/oracle/configure/doall.bat or doall.sh
To create table spaces without seed data, run
$MQ_HOME/db/oracle/configure/createusertablespace.sh or .bat
