Manage raster storage

最新推荐文章于 2022-02-25 20:00:37 发布

junmail

最新推荐文章于 2022-02-25 20:00:37 发布

阅读量181

点赞数

分类专栏： ArcSDE技术文章标签： Oracle F# UI C C++

ArcSDE技术专栏收录该内容

19 篇文章

订阅专栏

一、创建表空间
create tablespace versioned_data datafile '%oracle_base%\oradata\acf\versioned_data_01.dbf' size 101m uniform size 4M;

二、创建用户并授权
create user gisadmin identified by gisadmin default tablespace raster_data;
grant create session,create procedure,create table,create sequence,create trigger to gisadmin;
alter user gisadmin quota unlimited on raster_data;

三、导出dbtune表内容
sdedbtune -o export -f c:\dbtune_ex10.sde -u sde -p sde

四、往导出的文件中添加如下参数
##RASTER

GEOMETRY_STORAGE      "SDEOLB"
ATTRIBUTE_BINARY      "BOLB"
UI_TEXT               "USER INTERFACE TEXT"

B_INDEX_ROWID         "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
B_INDEX_SHAPE         "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
B_INDEX_USER          "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
B_STORAGE             "TABLESPACE raster_data PCTFREE 0 INITRANS 4"

F_INDEX_AREA          "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
F_INDEX_FID           "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
F_INDEX_LEN           "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
F_STORAGE             "TABLESPACE raster_data PCTFREE 0 INITRANS 4"

S_INDEX_ALL           "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
S_INDEX_SP_FID        "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
S_STORAGE             "TABLESPACE raster_data PCTFREE 0 INITRANS 4"

A_INDEX_ROWID         "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_SHAPE         "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_STATEID       "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_USER          "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_XML           "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
A_STORAGE             "TABLESPACE raster_data PCTFREE 0 INITRANS 4"

D_INDEX_DELETED_AT    "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
D_INDEX_STATE_ROWID   "TABLESPACE raster_data PCTFREE 0 INITRANS 4 NOLOGGING"
D_STORAGE             "TABLESPACE raster_data PCTFREE 0 INITRANS 4"

END

5、保存后，导入dbtune表的内容
sdedbtune -o import -f c:\dbtune_ex10.sde -u sde -p sde

6、导入数据即可