Adding a configuration keyword to the geodatabase table in Oracle for the Workflow Manager workspace

Available with Workflow Manager license.

After creating the data files, modify the DBTUNE table to include a new configuration keyword. Based on this new keyword, the data and database objects will be stored in the tablespaces location that was previously defined. The DBTUNE table is stored in the geodatabase in Oracle. To modify the DBTUNE table, it's necessary to export the DBTUNE table into a text file and make modifications in the text file. After the updates to the text file are made, import the new DBTUNE table from the text file.

Note:

Copying and pasting the examples may cause syntax errors.

1. Export the dbtune file before making any modifications.
   1. Start ArcCatalog.
   2. Open the ArcToolbox window.
   3. Open the Geodatabase Administration toolset in the Data Management Tools toolbox.
   4. Double-click the Export Geodatabase Configuration Keywords tool.
   5. Browse to the enterprise database connection, from which the file will be exported from, for Input Database Connection.
   6. Specify dbtune_exp.txt for Output File.
   7. Click OK.
2. Copy dbtune_exp.txt to dbtune_wmx.txt.
3. Using a file-based editor, modify the ##DEFAULTS keyword.

   dbtune_wmx.txt
   
   ##DEFAULTS
   A_INDEX_ROWID              "PCTFREE 0 INITRANS 4 TABLESPACE WMX_AINDEX STORAGE (INITIAL 409600) NOLOGGING "
   B_INDEX_TO_DATE            "PCTFREE 0 INITRANS 4 TABLESPACE WMX_BINDEX NOLOGGING"
   B_INDEX_XML                "PCTFREE 0 INITRANS 4 TABLESPACE WMX_BINDEX NOLOGGING"
   S_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE WMX_SDATA STORAGE (INITIAL 409600) "
   GEOMETRY_STORAGE           "ST_GEOMETRY"
   D_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE WMX_DDATA STORAGE (INITIAL 409600) "
   D_INDEX_STATE_ROWID        "PCTFREE 0 INITRANS 4 TABLESPACE WMX_DINDEX STORAGE (INITIAL 409600) NOLOGGING "
   B_INDEX_ROWID              "PCTFREE 0 INITRANS 4 TABLESPACE WMX_BINDEX STORAGE (INITIAL 409600) NOLOGGING "
   A_INDEX_USER               "PCTFREE 0 INITRANS 4 TABLESPACE WMX_AINDEX STORAGE (INITIAL 409600) NOLOGGING "
   A_INDEX_SHAPE              "PCTFREE 0 INITRANS 4 TABLESPACE WMX_AINDEX STORAGE (INITIAL 409600) NOLOGGING "
   F_INDEX_FID                "PCTFREE 0 INITRANS 4 TABLESPACE WMX_FINDEX NOLOGGING"
   F_INDEX_AREA               "PCTFREE 0 INITRANS 4 TABLESPACE WMX_FINDEX NOLOGGING"
   D_INDEX_DELETED_AT         "PCTFREE 0 INITRANS 4 TABLESPACE WMX_DINDEX STORAGE (INITIAL 409600) NOLOGGING "
   B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE WMX_BDATA STORAGE (INITIAL 409600) "
   B_INDEX_SHAPE              "PCTFREE 0 INITRANS 4 TABLESPACE WMX_BINDEX NOLOGGING"
   A_INDEX_RASTER             "PCTFREE 0 INITRANS 4 TABLESPACE WMX_AINDEX NOLOGGING"
   ST_GEOM_LOB_STORAGE        " STORE AS (TABLESPACE WMX_FDATA ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE INDEX (TABLESPACE WMX_FINDEX) )  "
   S_INDEX_SP_FID             "PCTFREE 0 INITRANS 4 TABLESPACE WMX_SINDEX NOLOGGING"
   S_INDEX_ALL                "PCTFREE 0 INITRANS 4 TABLESPACE WMX_SINDEX STORAGE (INITIAL 409600) NOLOGGING "
   F_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE WMX_FDATA "
   F_INDEX_LEN                "PCTFREE 0 INITRANS 4 TABLESPACE WMX_FINDEX NOLOGGING"
   B_INDEX_USER               "PCTFREE 0 INITRANS 4 TABLESPACE WMX_BINDEX STORAGE (INITIAL 409600) NOLOGGING "
   B_INDEX_RASTER             "PCTFREE 0 INITRANS 4 TABLESPACE WMX_BINDEX NOLOGGING"
   A_INDEX_XML                "PCTFREE 0 INITRANS 4 TABLESPACE WMX_AINDEX NOLOGGING"
   A_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE WMX_ADATA STORAGE (INITIAL 409600) "
   A_INDEX_STATEID            "PCTFREE 0 INITRANS 4 TABLESPACE WMX_AINDEX STORAGE (INITIAL 409600) NOLOGGING "
   END
   

4. Import the modified dbtune_wmx.txt file.
   1. Start ArcCatalog.
   2. Open the ArcToolbox window.
   3. Open the Geodatabase Administration toolset in the Data Management Tools toolbox.
   4. Double-click the Import Geodatabase Configuration Keywords tool.
   5. Browse to the enterprise database connection, to which the file will be imported into, for Input Database Connection.
   6. Browse to the dbtune_wmx.txt file for Input File.
   7. Click OK.

Feedback on this topic?