Edit the DBTUNE File

When an Oracle or SQLServer database is converted to an ArcFM database, the corresponding DBTUNE file can contain the keywords that are passed from ArcFM when the ArcFM System tables are created. Below is the text that can be added to your DBTUNE file for either Oracle or SQLServer if you choose to take advantage of this configuration option.

For Oracle databases: Append the following text to your DBTUNE file. This also provides support for BLOB fields in the ArcFM System tables. You need to edit the TABLESPACE value to reference an existing tablespace. e.g., “MINER” and “MINER_LOB_SEGMENT.” If you choose not to modify your DBTUNE settings, the ArcFM System tables will be created in the default tablespace assigned to the SDE user.

##MM_STORED_DISPLAYS
ATTRIBUTE_BINARY           "BLOB"
B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (MAP) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_PAGE_TEMPLATES
ATTRIBUTE_BINARY           "BLOB"
B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (TEMPLATE) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_PACKAGES
ATTRIBUTE_BINARY           "BLOB"
B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (CONTENTS) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_PERSIST_INFO
ATTRIBUTE_BINARY           "BLOB"
B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER ZZTABS LOB (Data) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_DESIGNER_FEAT
ATTRIBUTE_BINARY           "BLOB"
B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (Attributes) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_DESIGNER_CU
ATTRIBUTE_BINARY           "BLOB"
B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (MMCompatibleUnit) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_EDIT_LOG
ATTRIBUTE_BINARY           "BLOB"
B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (Data) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_DOCUMENTS
ATTRIBUTE_BINARY           "BLOB"
B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (DOCUMENT) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
UI_TEXT "Special Keyword for Miner system table of the same name"
END

For SQLServer: Append the following into your DBTUNE file. This allows the database to recognize the keywords passed by ArcFM when the ArcFM System tables are created. You need to edit the filegroup value, e.g., “MINER” and “MINER_DATA_IX” to reference an existing SQL Server filegroup. If you choose not to modify your DBTUNE settings, the ArcFM System tables will be created in the primary filegroup defined for the SDE user.

##MM_STORED_DISPLAYS
B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_PAGE_TEMPLATES
B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_PACKAGES
B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_PERSIST_INFO
B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_DESIGNER_FEAT
B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_DESIGNER_CU
B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_EDIT_LOG
B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
UI_TEXT "Special Keyword for Miner system table of the same name"
END
##MM_DOCUMENTS
B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
UI_TEXT "Special Keyword for Miner system table of the same name"
END