环境:
ArcSDE 10.1 SP1
Oracle 11.2.0.1
操作步骤:
1:修改Oracle的Open Cursors参数到5000
2:创建ArcSDE的分区策略
3:导入要素类,选择分区关键字
4:不停的进行平移,同时可以观察Oracle的Open Cursors参数会不断增加
5:等超过你设置的5000参数就会报ora-01000错误
One or more layers failed to draw:
TEST.hi: Underlying DBMS error [ORA-29902: 执行 ODCIIndexStart() 例行程序中出错
ORA-20101: ST_PARTITION_INDEX (select) error.ORA-01000: 超出打开游标的最大数
ORA-01000: 超出打开游标的最大数 -1000
ORA-06512: 在 "SDE.SPX_UTIL", line 4272
ORA-06512: 在 "SDE.ST_DOMAIN_METHODS", line 133
] [TEST.hi]
经过与美国Esri Support的沟通,确定为Bug:
NIM094929 Panning in ArcMap on feature class created with partitioned keyword for st_geometry table encounters error ORA-01000
该问题是新提交的bug ,什么是否修改到目前还没有计划,遇到此问题的用户可以时刻关注ArcGIS的补丁修复情况!
http://support.esri.com/en/downloads/patches-servicepacks
更新2014年10月8日
该问题已经解决:http://support.esri.com/en/downloads/patches-servicepacks/view/productid/67/metaid/2136
用户也可以查看相关的视频:http://screencast.com/t/38gBE3lxbaYw
关于其他的ArcSDE分区表技术文章参考:
- Configure the ArcSDE DBTUNE for creating a partitioned table in Oracle
Instructions provided demonstrate how to configure a business table's storage clause for creating a partitioned table in Oracle. - How is a partitioned spatial index on a partition table created in Oracle?
An ST_Geometry st_spatial_index domain index can be built to have discrete index partitions that correspond to each partition for range-partitioned tables. This type of index is called a local domain index, as opposed to a global domain index, whi... - Unable to perform spatial queries against a partitioned st_geometry table in Oracle
Performing a spatial query or using a st_geometry relational operator against a partitioned table with local st_spatial indexes fails with the following Oracle error ORA-29902: "SQL> SELECT owner, address, parcel_id 2 FROM parcels 3 WHERE... - Unable to create a partitioned local st_spatial_index in parallel in Oracle
Creating a partitioned local st_spatial_index in parallel fails with the following Oracle error: "ORA-12801: error signaled in parallel query server P000" and Oracle error: "ORA-29855: error occurred in the execution of ODCIINDEXCREATE ... - Unable to create local partitioned st_geometry_indexes in Oracle
Attempting to create a local partitioned st_geometry_index on a partitioned table in Oracle fails with underlying DBMS errors. {CODE}SQL> CREATE INDEX st_shape_index ON flight_path (shape) 2 INDEXTYPE IS sde.st_spatial_index 3 LOCAL (PART...
怎么在ArcSDE中使用Oracle分区表:
http://blog.csdn.net/linghe301/article/details/7177286
怎么在ArcSDE中使用Oracle分区表2-索引分区
http://blog.csdn.net/linghe301/article/details/8002950
-------------------------------------------------------------------------------------------------------
版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
出处来自:http://blog.csdn.net/linghe301
-------------------------------------------------------------------------------------------------------