ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

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?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal