Working with Data-Segment Table Tablespaces

To minimize disk contention, you can create a tablespace for the data-segment tables and store the data files for the tablespace on a separate physical disk. After creating the tablespace, you must change the Oracle Data Map Seg TableSpace Name and Oracle Data Seg TableSpace name to the new tablespace name.

  To rename tablespaces:

  1. Launch Workbench, and log on to the FDM application.

  2. Select Tools > Configuration Settings.

  3. Select Options > Oracle Data Map Seg TableSpace Name.

  4. In Name, enter the name of the new tablespace, and click Save.

  5. Select Options > Oracle Data Seg TableSpace Name.

  6. In Name, enter the name that you entered in step 4, and click Save.

  7. Click Close.

Note:

You can separate the data-map and data-seg tables into their own tablespaces, but no significant increase in performance can be expected.

After the tablespace names are specified, delete the data-map and data-seg tables from the Users tablespace and recreate them in the new tablespace.

Note:

You do not need to delete and re-create the data-map and data-seg tables if the new tablespace names were specified on the DB Options dialog box when the application was created.

Caution!

Deleting and recreating the data-map and data-seg tables truncates all table data. You should change tablespace names and re-create the tables after the application is created and before data is loaded.

  To re-create the data-map and data-seg tables:

  1. Launch Workbench, and log on to the FDM application.

  2. Select Tools > Manage Data Segments > Delete, Recreate, and Reassign All Segments.

    The Recreate Segments screen is displayed.

  3. Select the number of segments to create (default is 50) and click Save.

  4. Click Yes to verify that all data in the tables should be deleted.

After the data-map and data-seg tables are re-created, they are located in the tablespaces specified under Configuration Settings.