[Bug]ArcSDE分区表报:ORA-14301: table-level attributes must be specified before partition-level attribute

环境：

ArcSDE10.1 SP1  Oracle11.2.0.1 64Bit   

操作步骤：

1：ArcSDE分区设置

2：导入要素类，选择分区关键字

3：注册版本

4：进行数据归档（Data Archiving Enable）

进行数据归档报：ORA-14301: table-level attributes must be specified before partition-level attributes

-------------------------------------------------------------

我们跟着了Oracle的后台文件，因为报错原因是进行数据归档时，那么也就是可能是创建归档表的问题，获得创建归档表的语句

CREATE TABLE PAR2_H (OBJECTID NUMBER(38,0) NOT NULL, SHAPE SDE.ST_GEOMETRY NULL, GDB_FROM_DATE DATE NOT NULL, GDB_TO_DATE DATE 
NOT NULL) PCTFREE 0 INITRANS 4 PARTITION BY RANGE (OBJECTID) ( PARTITION CUS_PART1 VALUES LESS THAN (2000) 
TABLESPACE SDE, PARTITION CUS_PART2 VALUES LESS THAN (6000) TABLESPACE ESRI ) LOB (SHAPE.points) STORE AS (ENABLE 
STORAGE IN ROW CHUNK 8K PCTVERSION 0 CACHE) 

我们直接执行该语句，也报类似错误。

经过跟美国的Esri Support的沟通，确定是一个Bug：

NIM086501  Enable archiving failed with error ora-14302 on a partition table created using dbtune

该问题已经在ArcGIS10.2解决。

http://downloads.esri.com/support/downloads/other_/102-IssuesAddressedList.pdf

关于其他的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
-------------------------------------------------------------------------------------------------------