arcsde多版本问题

多版本视图

命令行

C:\Users\gyh>sdetable -o create_mv_view -T mv_water_pipe -t water_pipe -u VEOLIA
_KM_GIS_SDE -p VEOLIA_KM_GIS_SDE -s 192.168.0.175


ArcSDE 10.0  for Oracle11g Build 685 Fri May 14 12:05:43  2010
Attribute        Administration Utility
-----------------------------------------------------
Successfully created MV view mv_water_pipe for table water_pipe.

产生的SQL脚本

CREATE OR REPLACE VIEW MV_WATER_PIPE AS
SELECT b.OBJECTID,b.FEATID,b.OBJTYPE,b.DISTCODE,b.SUBTYPE,b.ASBUILT_DATE,b.ABANDONED_DATE,b.STATUS,b.PIPEID,b.PIPETYPE,b.MATERIAL,b.DIAMETER,b.BURIEDTYPE,b.JOINTYPE,b.IN_ANTICORROSIVE,b.NOMINALPRESSURE,b.IS_SPECIAL,b.SPECIAL_TYPE,b.USESTATUS,b.SYMBOL_LEVEL,b.MANUFACTURER,b.LENGTH,b.ASSETSLENGTH,b.PROJECTNAME,b.CONSTRUCTIONCOMPANY,b.INSTALLCOMPANY,b.ADDRESS,b.OWNER,b.MAINT_DIVISION,b.DATASOURCE,b.INPUTSTAFF,b.INPUTDATE,b.REMARK,b.PROJECTID,b.CASEID,b.ASSETID,b.CARDID,b.PHYSICALID,b.PHYSICALID2,b.MODELID,b.ID,b.ENABLED,b.ADMIN_DIVISION,b.SHAPE,0 SDE_STATE_ID,b.OPERATETYPE,b.TASK_ID FROM VEOLIA_KM_GIS_SDE.WATER_PIPE b,(SELECT SDE_DELETES_ROW_ID,SDE_STATE_ID FROM VEOLIA_KM_GIS_SDE.D1551 WHERE SDE_STATE_ID = 0 AND SDE.version_util.in_current_lineage (DELETED_AT) > 0) d WHERE b.OBJECTID = d.SDE_DELETES_ROW_ID(+) AND d.SDE_STATE_ID IS NULL UNION ALL SELECT a.OBJECTID,a.FEATID,a.OBJTYPE,a.DISTCODE,a.SUBTYPE,a.ASBUILT_DATE,a.ABANDONED_DATE,a.STATUS,a.PIPEID,a.PIPETYPE,a.MATERIAL,a.DIAMETER,a.BURIEDTYPE,a.JOINTYPE,a.IN_ANTICORROSIVE,a.NOMINALPRESSURE,a.IS_SPECIAL,a.SPECIAL_TYPE,a.USESTATUS,a.SYMBOL_LEVEL,a.MANUFACTURER,a.LENGTH,a.ASSETSLENGTH,a.PROJECTNAME,a.CONSTRUCTIONCOMPANY,a.INSTALLCOMPANY,a.ADDRESS,a.OWNER,a.MAINT_DIVISION,a.DATASOURCE,a.INPUTSTAFF,a.INPUTDATE,a.REMARK,a.PROJECTID,a.CASEID,a.ASSETID,a.CARDID,a.PHYSICALID,a.PHYSICALID2,a.MODELID,a.ID,a.ENABLED,a.ADMIN_DIVISION,a.SHAPE,a.SDE_STATE_ID,a.OPERATETYPE,a.TASK_ID FROM VEOLIA_KM_GIS_SDE.A1551 a,(SELECT SDE_DELETES_ROW_ID,SDE_STATE_ID FROM VEOLIA_KM_GIS_SDE.D1551 WHERE SDE.version_util.in_current_lineage (DELETED_AT) > 0) d WHERE a.OBJECTID = d.SDE_DELETES_ROW_ID(+) AND a.SDE_STATE_ID = d.SDE_STATE_ID(+) AND SDE.version_util.in_current_lineage (a.SDE_STATE_ID) > 0 AND d.SDE_STATE_ID IS NULL;

切换版本，查看其它版本化数据

--查看所有版本信息

select * from versions t

最忐忑的是怕它是系统级的还好是会话级的

主要：不应将多版本化视图用于访问或修改复杂要素（例如，参与几何网络、拓扑、terrain、地籍结构、网络数据集或关系的要素，或具有特定地理数据库行为的要素）。应使用 ArcGIS 来查看和修改这些类型的要素。做一些查询统计还是不错的

参照：http://help.arcgis.com/zh-cn/arcgisserver/10.0/help/arcgis_server_java_help/index.html#/na/00920000139r000000/

空间数据库专项研究群：Oracle+Arcsde：278243013