需要 Data Reviewer 许可。
在创建数据文件之后,修改 DBTUNE 表以加入新的配置关键字。根据此新关键字,数据和数据库对象将存储在之前定义的表空间位置中。DBTUNE 表存储在 Oracle 中的地理数据库中。要修改 DBTUNE 表,有必要将 DBTUNE 表导出至文本文件中,并在文本文件中进行修改。在对文本文件进行更新后,从文本文件中导入新的 DBTUNE 表。
- Export the dbtune file before making any modifications.
- Start ArcCatalog.
- Click the ArcToolbox button
on the Standard toolbar.
- Expand Data Management Tools > Geodatabase Administration..
- Double-click Export Geodatabase Configuration Keywords.
The Export Geodatabase Configuration Keywords dialog box appears.
- Click the browse folder for the Input Database Connection parameter and browse to the connection file for the enterprise geodatabase you want to export.
- Click the browse folder for the Output File parameter and browse to the path where the file will be exported.
- Name the file dbtune_exp.txt and click Save.
- Click OK on the Export Geodatabase Configuration Keywords dialog box.
- 将 dbtune_exp.txt 复制到 dbtune_rev.txt。
- 使用基于文件的编辑器修改 ##DEFAULTS 关键字并将其粘贴到名为 dbtune_rev.sde 的文件的末端。
- 重命名为 ##REVIEWER,并相应更改参数的表空间名称。
dbtune_rev.txt ##DEFAULTS A_INDEX_RASTER "PCTFREE 0 INITRANS 4 TABLESPACE REV_AINDEX NOLOGGING" A_INDEX_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE REV_AINDEX STORAGE (INITIAL 409600) NOLOGGING" A_INDEX_SHAPE "PCTFREE 0 INITRANS 4 TABLESPACE REV_AINDEX STORAGE (INITIAL 409600) NOLOGGING" A_INDEX_STATEID "PCTFREE 0 INITRANS 4 TABLESPACE REV_AINDEX STORAGE (INITIAL 409600) NOLOGGING" A_INDEX_USER "PCTFREE 0 INITRANS 4 TABLESPACE REV_AINDEX STORAGE (INITIAL 409600) NOLOGGING" A_INDEX_XML "PCTFREE 0 INITRANS 4 TABLESPACE REV_AINDEX NOLOGGING" A_STORAGE "PCTFREE 0 INITRANS 4 TABLESPACE REV_ADATA STORAGE (INITIAL 409600)" B_INDEX_RASTER "PCTFREE 0 INITRANS 4 TABLESPACE REV_BINDEX NOLOGGING" B_INDEX_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE REV_BINDEX STORAGE (INITIAL 409600) NOLOGGING" B_INDEX_SHAPE "PCTFREE 0 INITRANS 4 TABLESPACE REV_BINDEX NOLOGGING" B_INDEX_TO_DATE "PCTFREE 0 INITRANS 4 TABLESPACE REV_BINDEX NOLOGGING" B_INDEX_USER "PCTFREE 0 INITRANS 4 TABLESPACE REV_BINDEX STORAGE (INITIAL 409600) NOLOGGING" B_INDEX_XML "PCTFREE 0 INITRANS 4 TABLESPACE REV_BINDEX NOLOGGING" B_STORAGE "PCTFREE 0 INITRANS 4 TABLESPACE REV_BDATA STORAGE (INITIAL 409600)" D_INDEX_DELETED_AT "PCTFREE 0 INITRANS 4 TABLESPACE REV_DINDEX STORAGE (INITIAL 409600) NOLOGGING" D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 TABLESPACE REV_DINDEX STORAGE (INITIAL 409600) NOLOGGING" D_STORAGE "PCTFREE 0 INITRANS 4 TABLESPACE REV_DDATA STORAGE (INITIAL 409600)" F_INDEX_AREA "PCTFREE 0 INITRANS 4 TABLESPACE REV_FINDEX NOLOGGING" F_INDEX_FID "PCTFREE 0 INITRANS 4 TABLESPACE REV_FINDEX NOLOGGING" F_INDEX_LEN "PCTFREE 0 INITRANS 4 TABLESPACE REV_FINDEX NOLOGGING" F_STORAGE "PCTFREE 0 INITRANS 4 TABLESPACE REV_FDATA" GEOMETRY_STORAGE "ST_GEOMETRY" S_INDEX_ALL "PCTFREE 0 INITRANS 4 TABLESPACE REV_SINDEX STORAGE (INITIAL 409600) NOLOGGING" S_INDEX_SP_FID "PCTFREE 0 INITRANS 4 TABLESPACE REV_SINDEX NOLOGGING" S_STORAGE "PCTFREE 0 INITRANS 4 TABLESPACE REV_SDATA STORAGE (INITIAL 409600)" ST_GEOM_LOB_STORAGE "STORE AS (TABLESPACE REV_FDATA ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE INDEX (TABLESPACE REV_FINDEX) )" END
- 使用 ArcCatalog 或 ArcMap 导入经过修改的 dbtune_rev.txt 文件。
- 在 ArcToolbox 窗口中,展开数据管理工具 > 地理数据库管理。
- 双击导入地理数据库配置关键字工具。
将弹出导入地理数据库配置关键字对话框。
- 单击输入数据库连接参数旁的浏览文件夹,浏览需要导入企业级地理数据库的连接文件。
- 单击输入文件参数的浏览文件夹,浏览至文件的导入路径。
- 将文件命名为 dbtune_rev.txt,然后单击打开。
- 单击导入地理数据库配置关键字对话框上的确定。