Creating Table spaces - Alternative Approach

In this approach, TIBCO MDM creates and manages table spaces. A separate table space is created for each enterprise that is used for data source upload.

1. Create two different table spaces, VELODBDATA and VELODBINDX.
2. Create mdmadm user identified by password default table space VELODBDATA temporary table space temp.
3. Grant connect, resource to mdmadm.
4. Alter user mdmadm quota 1000m on VELODBINDX.
5. Grant create tablespace privilege to mdmadm.
6. Grant UNLIMITED TABLESPACE privilege to mdmadm.
7. Set the following properties using Configurator: 
(Advanced view, Database, Oracle).
   1. Set DatabaseTablespace Create Privilege to True.
      Note: For CSV data upload, you need to set the option to False.
   2. Set DatabaseTable Space Name to VELODBDF. The default value is USERS.
   3. Set DatabaseMaster Catalog/Repository Data Table Space to VELODBDATA. The default value is USERS.
   4. Set DatabaseMaster Catalog/Repository Index Table Space to VELODBINDX. The default value is USERS.
      Note: With this approach, you need to create table space privileges for the TIBCO MDM database user.
8. If TIBCO MDM is responsible for creating a table space for each enterprise on the first data load, set the following properties using Configurator (Go to Initial Config > Databasedatabasename ):

   • Table Space File Size 
     Table Space Next Size
     Table Space Initial Storage Size
     Table Space Increase %

     For the following properties, go to Initial Config > Database:

   • Dynamic Table Space Location
     Table Space Name Prefix

     After completion, you can create the seed data. See One Two or Three Table spaces Option.