[Bug]ArcSDE分区表报：ORA-01000 maximum open cursors exceeded

环境：

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
-------------------------------------------------------------------------------------------------------