环境:
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
-------------------------------------------------------------------------------------------------------