Adding a configuration keyword to the DBTUNE in Oracle for the Production Mapping workspace (Production Mapping)

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.

RemarqueRemarque :

Copying and pasting the example may cause syntax errors.

Etapes :
  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:pmdb
    
  2. Copy dbtune_exp.sde to dbtune_pm.sde.
  3. Using a file-based editor, modify the keywords.
    dbtune_pm.sde
    
    ##DATA_DICTIONARY
    ATTRIBUTE_BINARY		"BLOB"
    B_STORAGE               "PCTFREE 0 INITRANS 4 TABLESPACE SDEDICT STORAGE (INITIAL 40K)"
    B_INDEX_ROWID           "PCTFREE 0 INITRANS 4 TABLESPACE SDEDICTINDEX STORAGE (INITIAL 40K) NOLOGGING"
    B_INDEX_USER            "PCTFREE 0 INITRANS 4 TABLESPACE SDEDICTINDEX STORAGE (INITIAL 40K) NOLOGGING"
    STATES_TABLE            "INITRANS 4 TABLESPACE SDEDICT STORAGE (INITIAL 1M)"
    STATES_INDEX            "INITRANS 5 TABLESPACE SDEDICTINDEX STORAGE (INITIAL 128K) NOLOGGING"
    STATE_LINEAGES_TABLE    "PCTFREE 0 INITRANS 4 TABLESPACE SDEDICT STORAGE (INITIAL 7M)"
    STATE_LINEAGES_INDEX    "PCTFREE 0 INITRANS 4 TABLESPACE SDEDICTINDEX STORAGE (INITIAL 5M) NOLOGGING"
    VERSIONS_TABLE          "INITRANS 4 TABLESPACE SDEDICT STORAGE (INITIAL 256K)"
    VERSIONS_INDEX          "INITRANS 4 TABLESPACE SDEDICTINDEX STORAGE (INITIAL 128K) NOLOGGING"
    MVTABLES_MODIFIED_TABLE "INITRANS 4 TABLESPACE SDEDICT STORAGE (INITIAL 2M)"
    MVTABLES_MODIFIED_INDEX "INITRANS 4 TABLESPACE SDEDICTINDEX STORAGE (INITIAL  2M) NOLOGGING"
    XML_INDEX_TAGS_TABLE    "INITRANS 4 TABLESPACE SDEDICT STORAGE (INITIAL 1M)"
    XML_INDEX_TAGS_INDEX    "INITRANS 5 TABLESPACE SDEDICTINDEX STORAGE (INITIAL 1M)"
    END
    
    ##DEFAULTS
    GEOMETRY_STORAGE    "ST_GEOMETRY"
    ST_GEOM_LOB_STORAGE  " STORE AS (TABLESPACE PM_FDATA ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE INDEX (TABLESPACE PM_FINDEX)) "
    ATTRIBUTE_BINARY    "BLOB"
    RASTER_STORAGE	    "BLOB"
    B_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_BDATA"
    B_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_BINDEX NOLOGGING"
    B_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_BINDEX NOLOGGING"
    B_INDEX_XML         "PCTFREE 0 INITRANS 4 TABLESPACE PM_BINDEX NOLOGGING"
    B_INDEX_RASTER      "PCTFREE 0 INITRANS 4 TABLESPACE PM_BINDEX NOLOGGING"
    B_INDEX_TO_DATE     "PCTFREE 0 INITRANS 4 TABLESPACE PM_BINDEX NOLOGGING"
    S_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_SDATA"
    S_INDEX_ALL         "PCTFREE 0 INITRANS 4 TABLESPACE PM_SINDEX NOLOGGING"
    A_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_ADATA"
    A_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_STATEID     "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_XML         "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_RASTER      "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    D_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_DDATA"
    D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    D_INDEX_DELETED_AT  "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    RAS_STORAGE         "PCTFREE 0 INITRANS 4 TABLESPACE PM_RASTER"
    RAS_INDEX_ID        "PCTFREE 0 INITRANS 4 TABLESPACE PM_RINDEX NOLOGGING"
    BND_STORAGE         "PCTFREE 0 INITRANS 4 TABLESPACE PM_RASTER"
    BND_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 TABLESPACE PM_RINDEX NOLOGGING"
    BND_INDEX_ID        "PCTFREE 0 INITRANS 4 TABLESPACE PM_RINDEX NOLOGGING"
    AUX_STORAGE         "PCTFREE 0 INITRANS 4 TABLESPACE PM_RASTER"
    AUX_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 TABLESPACE PM_RINDEX NOLOGGING"
    BLK_STORAGE         "PCTFREE 0 INITRANS 4 TABLESPACE PM_RBLK"
    BLK_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 TABLESPACE PM_RBLKIDX NOLOGGING"
    UI_TEXT             "User Interface text for DEFAULTS" 
    XML_DOC_UNCOMPRESSED_TYPE   "CLOB"
    XML_IDX_TEXT_UPDATE_METHOD "NONE"
    XML_DOC_MODE               "COMPRESSED"
    XML_DOC_LOB_STORAGE        "NOCACHE NOLOGGING CHUNK 4K PCTVERSION 5 DISABLE STORAGE IN ROW TABLESPACE PM_XMLDOC"
    XML_DOC_VAL_LOB_STORAGE    "NOCACHE NOLOGGING CHUNK 4K PCTVERSION 5 DISABLE STORAGE IN ROW TABLESPACE PM_XMLDOC"
    XML_DOC_STORAGE     "PCTFREE 0 INITRANS 4 TABLESPACE PM_XMLDOC"
    XML_DOC_INDEX       "PCTFREE 0 INITRANS 4 TABLESPACE PM_XMLIDX NOLOGGING"
    XML_IDX_STORAGE     "PCTFREE 0 INITRANS 4 TABLESPACE PM_XMLIDX"
    XML_IDX_TEXT_TAG_STORAGE   ""
    XML_IDX_INDEX_PK    "PCTFREE 0 INITRANS 4 TABLESPACE PM_XMLIDX NOLOGGING"
    XML_IDX_INDEX_ID    "PCTFREE 0 INITRANS 4 TABLESPACE PM_XMLIDX NOLOGGING"
    XML_IDX_INDEX_TEXT  ""
    XML_IDX_TEXT_UPDATE_MEMORY ""
    XML_IDX_INDEX_TAG    "PCTFREE 0 INITRANS 4 TABLESPACE PM_XMLIDX NOLOGGING"
    XML_IDX_INDEX_DOUBLE "PCTFREE 0 INITRANS 4 TABLESPACE PM_XMLIDX NOLOGGING"                   
    XML_IDX_INDEX_STRING "PCTFREE 0 INITRANS 4 TABLESPACE PM_XMLIDX NOLOGGING"                   
    END
    
    ##SDO_GEOMETRY
    GEOMETRY_STORAGE    "SDO_GEOMETRY"
    ATTRIBUTE_BINARY    "BLOB"
    RASTER_STORAGE	  "SDO_GEORASTER"
    SDO_COMMIT_INTERVAL  1000
    UI_TEXT             "User Interface text description for SDO_GEOMETRY"
    COMMENT             "Any general comment for SDO_GEOMETRY keyword"
    END
    
    ##SDO_GEORASTER
    GEOMETRY_STORAGE    "SDO_GEOMETRY"
    RASTER_STORAGE      "SDO_GEORASTER"
    ATTRIBUTE_BINARY    "BLOB"
    SDO_COMMIT_INTERVAL  1000
    RDT_STORAGE         "PCTFREE 0 INITRANS 4 TABLESPACE PM_RASTER"
    RDT_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 TABLESPACE PM_RINDEX STORAGE ( INITIAL 409600) NOLOGGING"
    UI_TEXT             "User Interface text description for SDO_GEORASTER"
    COMMENT             "Any general comment for SDO_GEORASTER keyword"
    END
    
    ##SDELOB
    GEOMETRY_STORAGE    "SDELOB"
    ATTRIBUTE_BINARY    "BLOB"
    RASTER_STORAGE	  "BLOB"
    B_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_BINDEX NOLOGGING"
    F_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_FDATA"
    F_INDEX_FID         "PCTFREE 0 INITRANS 4 TABLESPACE PM_FINDEX NOLOGGING"
    F_INDEX_AREA        "PCTFREE 0 INITRANS 4 TABLESPACE PM_FINDEX NOLOGGING"
    F_INDEX_LEN         "PCTFREE 0 INITRANS 4 TABLESPACE PM_FINDEX NOLOGGING"
    S_INDEX_SP_FID      "PCTFREE 0 INITRANS 4 TABLESPACE PM_SINDEX NOLOGGING"
    UI_TEXT             "User Interface text description for SDELOB"
    COMMENT             "Any general comment for SDELOB keyword"
    END
    
    ##WKB_GEOMETRY
    GEOMETRY_STORAGE    "OGCWKB"
    ATTRIBUTE_BINARY    "BLOB"
    RASTER_STORAGE      "BLOB"
    UI_TEXT             "User Interface text description for OGC WKB"
    END
    
    ##LOGFILE_DEFAULTS
    LF_STORAGE          "PCTFREE 0 INITRANS 4 TABLESPACE SDELOGFILE"
    LF_INDEXES          "PCTFREE 0 INITRANS 4 TABLESPACE SDELOGFILEIDX NOLOGGING"
    LD_STORAGE          "PCTFREE 0 INITRANS 4 TABLESPACE SDELOGFILE"
    LD_INDEX_ROWID      "PCTFREE 0 INITRANS 4 TABLESPACE SDELOGFILEIDX NOLOGGING"
    LD_INDEX_DATA_ID    "PCTFREE 0 INITRANS 4 TABLESPACE SDELOGFILEIDX NOLOGGING"
    SESSION_STORAGE     "PCTFREE 0 INITRANS 4 TABLESPACE SDELOGFILE"
    SESSION_INDEX       "PCTFREE 0 INITRANS 4 TABLESPACE SDELOGFILEIDX NOLOGGING"
    SESSION_TEMP_TABLE 0
    END
    
    ##NETWORK_DEFAULTS
    ATTRIBUTE_BINARY    "BLOB"
    B_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_BDATA"                    
    B_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_BINDEX NOLOGGING"
    B_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_BINDEX NOLOGGING"
    B_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_BINDEX NOLOGGING"
    F_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_FDATA"
    F_INDEX_FID         "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_FINDEX NOLOGGING"
    F_INDEX_AREA        "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_FINDEX NOLOGGING"
    F_INDEX_LEN         "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_FINDEX NOLOGGING"
    S_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_SDATA"
    S_INDEX_ALL         "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_SINDEX NOLOGGING"
    S_INDEX_SP_FID      "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_SINDEX NOLOGGING"
    A_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_ADATA"
    A_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_STATEID     "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    D_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_DDATA"
    D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    D_INDEX_DELETED_AT  "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    COMMENT             "The base system initialization parameters for NETWORK_DEFAULTS"
    UI_NETWORK_TEXT     "The network default configuration"
    END
    
    ##NETWORK_DEFAULTS::DESC
    B_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_BDATA"
    B_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_BINDEX NOLOGGING"
    B_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_BINDEX NOLOGGING"
    A_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_ADATA"
    A_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_STATEID     "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    D_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_DDATA"
    D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    D_INDEX_DELETED_AT  "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    END
    
    ##NETWORK_DEFAULTS::NETWORK
    B_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_BDATA"
    B_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_BINDEX NOLOGGING"
    B_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_NET_BINDEX NOLOGGING"
    A_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_ADATA"
    A_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_STATEID     "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    D_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_DDATA"
    D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    D_INDEX_DELETED_AT  "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    END
    
    
    ##IMS_GAZETTEER
    XML_DOC_LOB_STORAGE        "NOCACHE NOLOGGING CHUNK 4K PCTVERSION 5"
    XML_DOC_VAL_LOB_STORAGE    "NOCACHE NOLOGGING CHUNK 4K PCTVERSION 5"
    END
    
    ##TOPOLOGY_DEFAULTS
    UI_TOPOLOGY_TEXT    "The topology default configuration"
    B_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_BDATA"     
    B_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_BINDEX NOLOGGING"
    B_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_BINDEX NOLOGGING"
    B_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_BINDEX NOLOGGING"
    F_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_FDATA"
    F_INDEX_AREA        "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_FINDEX NOLOGGING"
    F_INDEX_FID         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_FINDEX NOLOGGING"
    F_INDEX_LEN         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_FINDEX NOLOGGING"
    S_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_SDATA"
    S_INDEX_ALL         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_SINDEX NOLOGGING"
    S_INDEX_SP_FID      "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_SINDEX NOLOGGING"
    A_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_ADATA"
    A_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_STATEID     "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    D_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_DDATA"
    D_INDEX_DELETED_AT  "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    END
    
    ##TOPOLOGY_DEFAULTS::DIRTYAREAS
    B_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_BDATA"
    B_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_BINDEX NOLOGGING"
    B_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_BINDEX NOLOGGING"
    B_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_BINDEX NOLOGGING"
    F_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_FDATA"
    F_INDEX_AREA        "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_FINDEX NOLOGGING"
    F_INDEX_FID         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_FINDEX NOLOGGING"
    F_INDEX_LEN         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_FINDEX NOLOGGING"
    S_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_SDATA"
    S_INDEX_ALL         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_SINDEX NOLOGGING"
    S_INDEX_SP_FID      "PCTFREE 0 INITRANS 4 TABLESPACE PM_TOPO_SINDEX NOLOGGING"
    A_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_ADATA"
    A_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_STATEID     "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    D_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_DDATA"
    D_INDEX_DELETED_AT  "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    END
    
    ##TERRAIN_DEFAULTS
    UI_TERRAIN_TEXT    "The terrain default configuration"
    B_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_BDATA"
    B_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_BINDEX NOLOGGING"
    B_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_BINDEX NOLOGGING"
    B_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_BINDEX NOLOGGING"
    F_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_FDATA"   
    F_INDEX_AREA        "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_FINDEX NOLOGGING"
    F_INDEX_FID         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_FINDEX NOLOGGING"
    F_INDEX_LEN         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_FINDEX NOLOGGING"
    S_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_SDATA"
    S_INDEX_ALL         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_SINDEX NOLOGGING"
    S_INDEX_SP_FID      "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_SINDEX NOLOGGING"
    A_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_ADATA"
    A_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_STATEID     "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    D_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_DDATA"
    D_INDEX_DELETED_AT  "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    END
    
    ##TERRAIN_DEFAULTS::EMBEDDED
    B_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_BDATA"
    B_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_BINDEX NOLOGGING"
    B_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_BINDEX NOLOGGING"
    B_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_BINDEX NOLOGGING"
    F_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_FDATA"
    F_INDEX_AREA        "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_FINDEX NOLOGGING"
    F_INDEX_FID         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_FINDEX NOLOGGING"
    F_INDEX_LEN         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_FINDEX NOLOGGING"
    S_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_SDATA"
    S_INDEX_ALL         "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_SINDEX NOLOGGING"
    S_INDEX_SP_FID      "PCTFREE 0 INITRANS 4 TABLESPACE PM_TERRAIN_SINDEX NOLOGGING"
    A_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_ADATA"
    A_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_STATEID     "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    A_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE PM_AINDEX NOLOGGING"
    D_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE PM_DDATA"
    D_INDEX_DELETED_AT  "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE PM_DINDEX NOLOGGING"
    END
    
    ##ST_RASTER
    RASTER_STORAGE             "ST_RASTER"
    UI_TEXT                    "UI_TEXT"
    END
    
  4. From the command prompt, import the modified dbtune_pm.sde file.
    sdedbtune -o import -f dbtune_pm.sde -u sde -p sde -i 
    sde:oracle11g:pmdb
    
4/26/2014