Working with ArcSDE 10.1 and Oracle spatial 11g.
I set the feature class in load_only_io before loading shapefiles. I am using geoprocessing tool (append) in ArcGIS to load shapefile to geodatabase. After loading ArcGIS is creating spatial index on sdo_geometry.
How to disable this automatic index creation?
I want to load shapefiles and later I want to create index myself.
-
Please edit the question to include the exact methodology you are using to populate the table.Vince– Vince2015年05月13日 10:52:13 +00:00Commented May 13, 2015 at 10:52
1 Answer 1
As per Documentation:
With ArcSDE, putting a feature class in load-only mode disables updating of the spatial index while data is loading. In a File Geodatabase, putting a feature class or table in load-only mode disables updating of spatial and attribute indexes while data is loading. Taking the feature class or table out of load-only mode rebuilds the indexes.
Therefore to prevent from index rebuild (or creation), don't take your FC out of load-only mode. After loading all the features, turn off the load-only mode.
If you don't like this behavior, you should manually drop any spatial indexes and insert all rows/features and then create the index manually yourself.
-
I am not taking FC out of load_only mode, but it creates spatial indexJaya Sudha– Jaya Sudha2015年05月14日 12:25:26 +00:00Commented May 14, 2015 at 12:25
-
With load-only-mode, you need to acquire a schema lock (ISchemaLock). once you release the lock, load only mode will be turned off!Farid Cheraghi– Farid Cheraghi2015年05月14日 12:50:26 +00:00Commented May 14, 2015 at 12:50
-
1I am loading shape file using append geoprocessing toolJaya Sudha– Jaya Sudha2015年05月15日 04:16:22 +00:00Commented May 15, 2015 at 4:16
-
Any suggestions on this problem ??Jaya Sudha– Jaya Sudha2015年06月11日 05:27:25 +00:00Commented Jun 11, 2015 at 5:27
Explore related questions
See similar questions with these tags.