Oracle Only - Create a Tablespace for Records

If you are using an Oracle database, you need to create a separate tablespace for the following records:
  • TIB_CI_BUS_DTL
  • TIB_CI_BUS_HDR
  • TIB_CI_MQUEUE
  • TIB_CI_SEQUENCE
  • TIB_CI_TIDLOG

To create a tablespace and assign records:

Procedure

  1. Create a tablespace in the Oracle database exclusively for records. The recommended size for the tablespace is 50MB. If you want to increase the tablespace size, contact your database administrator.
  2. Open PeopleTools Application Designer and log in to the target server where you added the project.
  3. Open a record(s) to be allocated to the new tablespace.
  4. From the menu, select Tools > Data Administration > Set Tablespace.
  5. Select Oracle from the Platform drop-down list.
  6. Select the created tablespace from Available Space Name-DB Name drop-down list. Change the original setting if required.
  7. Click OK.
  8. Save the record(s). A new tablespace is added to the record(s).
  9. Repeat step 3 to step 8 to add the tablespace to the five records.
  10. Save the project and exit PeopleTools Application Designer.