laptop and a wrench

Bug

Enable archiving failed with error ora-14302 on a partition table created after modifying the B_STORAGE option in the dbtune.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM086501
SubmittedNovember 13, 2012
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found10.1
Version Fixed10.2
StatusFixed

Workaround

1. Create a table in Oracle according to example given below:CREATE TABLE citytest(objectid number(38) not null,name varchar2(50), place_key VARCHAR2(10), Capital varchar(1),POPULATION NUMBER(38),PCLASS VARCHAR2(2),shape sde.st_geometry)PARTITION BY RANGE (OBJECTID)(PARTITION CUS_PART1 VALUES LESS THAN (2000) TABLESPACE SDE,PARTITION CUS_PART2 VALUES LESS THAN (6000) TABLESPACE ESRI);2. Register with geodatabase using ArcCatalog 10.1 as a point feature class.3. Load data.4. Register the feature class as versioned.5. Enable Archiving.

Steps to Reproduce

Bug ID: NIM086501

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options