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

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 under the sde user 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.

If you only use direct connections at your site, you may not have installed ArcSDE. You need to install ArcSDE, if you haven't already, to get the sdedbtune and sdeconfig tools.

NoteNote:

Copying and pasting the examples may cause syntax errors.

Steps:
  1. From the command prompt, export the dbtune file before making any modifications.
    sdedbtune -o export -f dbtune_exp.sde -u sde -p sde -i 
    sde:oracle11g:wmxdb
    
  2. Copy dbtune_exp.sde to dbtune_wmx.sde.
  3. Using a file-based editor, modify the ##DEFAULTS keyword.
    dbtune_wmx.sde
    
    ##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. From the command prompt, import the modified dbtune_wmx.sde file.
    sdedbtune -o import -f dbtune_wmx.sde -u sde -p sde -i 
    sde:oracle11g:wmxdb
    
3/3/2014